SDSU Finding The Variable Using Excel Worksheet I’m providing all the documents my professor provided. Follow directions. Use the Excel Data. Complete the
SDSU Finding The Variable Using Excel Worksheet I’m providing all the documents my professor provided. Follow directions. Use the Excel Data. Complete the assignment (25 Questions). Chap 12_Assignment_1~Way Anova_ 4:00
1
2
3
4
5
6
7
8
GENERAL QUESTIONS
ANOVA uses the ______ to compare means
Another name for treatment is
?
Which of the following is nominal level data?
The denominator in the F-test measures..?
Variability: sample means to the grand mean
?
As the # of samples rises the chances of a
?
If Test Stat < 1, there is more variation
If all the samples sizes are equal the Anova is
not strictly bound by what test assumption?
Groups
Synchronous
Asynchronous
Hybrid
Source of Variation
Between Groups
Within Groups
Total
ANSWERS
Choose an item.
Choose an item.
Choose an item.
Choose an item.
Choose an item.
Choose an item.
Choose an item.
Choose an item.
Sample Size
5
5
5
Sum
562
577
570
Average
80.00
82.00
79.00
Variance
6.00
4.00
3.00
SS
A
B
C
df
D
E
F
MS
G
H
F
I
1
2
3
4
5
6
7
8
16
12
P-value
J
F crit
K
9
10
11
12
13
USE THE ABOVE TABLES FOR QUES. 9 - 13
What is the value of the Yellow Cell?
What is the value of CELL B?
What is the value of CELL F?
How is CELL I calculated?
How many 2 sample T-test could be run?
ANSWERS
Choose an item.
Choose an item.
Choose an item.
Choose an item.
Choose an item.
9
10
11
12
13
14
15
16
17
18
QUESTIONS FOR THE MAMMOGRAM DATA
What is the Criterion Variable?
What is the Classification Variable?
How many categories are there?
True/False? H0: ?1 = ?2 = ?3
True/False? H1: ?1 ? ?2 ? ?3
ANSWERS
Choose an item.
Choose an item.
Choose an item.
Choose an item.
Choose an item.
14
15
16
17
18
What is the Test Statistic?
What is your test decision?
What accounts for the variation in the data?
Which of the following best describes the data?
Choose
Choose
Choose
Choose
19
20
21
22
23
25
©KShaul 2020
COPY & PASTE YOUR ANOVA TABLES BELOW
an
an
an
an
item.
item.
item.
item.
19
20
21
22
23
25
Chap 12_Assignment_1~Way Anova_ 4:00
©KShaul 2020
Years Since Last Mammogram for 3 Income Levels
Patient
1*
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
1. < $20K
2
2
2
2
2
2
2
3
3
3
3
4
4
4
4
5
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
7
7
7
10
11
12
12
2. $20K - $80K
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
4
4
4
4
4
4
5
5
5
5
6
6
7
7
7
8
8
8
9
10
12
12
12
3. > $80K
2
2
2
2
2
2
2
2
3
4
4
4
5
5
5
6
6
7
7
7
7
8
8
8
9
9
9
9
9
9
9
9
10
10
11
12
12
12
13
14
*The values for each patient in columns B, C, and D are the
number of years since last mammogram
Chapter 12: 1-Way Anova Excel
The data is a subset of large dataset from a study involving female patients at a New York City
hospital. In particular, the included data is a record of the Number of Years since last
mammogram for females across three income levels.
The researcher wanted to see if income might be a proxy for other factors that influenced how
long women took between mammograms and (when checked across another set of data)
whether these women were equally likely to be diagnosed with breast cancer.
STEPS
1. Open the Excel Sheet.
2. Click on the Data Tab ? Data Analysis ? Select Anova: Single Factor
Pop Up Box Inputs
A. Input Range: $B$3:$D$43 (Include the Income Levels as Labels. Do NOT include the
Patient column.)
B. Grouped by Columns (Default Choice)
C. Labels in the first row
D. Alpha = .05
E. Output Range: Anywhere other than over the data set
F. OK
3. Format:
A. Column widths so all headings are legible
B. Numbers to 3 decimal places
C. Delete:
a) the empty row between Anova: Single Factor and SUMMARY
b) one of the two empty rows between the first table and the word ANOVA of
the second table so there is only one empty row between tables
c) the empty row (if there is one) between the Within Groups and Total in the
Anova table
4. COMPLETE THE C 12 ASSIGNMENT AND SUBMIT VIA THE PROPER LINK
©KShaul 2020
Chap 12: 1-Way Anova
Terms:
1. Classification Variable the overarching nominal level descriptor (other names: Factor or
Treatment). The 1 in 1-way refers to the classification variable
2. Categoriesthe individual sample names
3. Criterion Variablethe variable being tested/compared (other name: Variable of Interest)
4. SStotaltotal variation for all data points and all samples (SS = Sum of the Squares)
5. SSbetweenvariation due to the classification variable (SS = Sum of the Squares)
6. SSwithinvariation due to chance (SS = Sum of the Squares)
7. Sum of the Squaresthe numerator of the variance = ?(?? ? ??? )2 . Note: The equation has ?
and 2, and thus Sum of the Squares
Anova Table
Source of Variation
Between Groups
SS
÷
SSbn
DF =
MS
F
n -1*
MSbn
= TS
Within Groups
_+__SSw/n___
nt-k*
Total
= SStotal
nt-1*
P-value
F crit
DF bn and
Df w/n
MSw/n
SS column and DF column are additive. As in the drawing the lines of SSbn and SSw/n = SStotal.
DF:
n = # of categories and nt = total # of data points
SS ÷ DF = MS
MSbn ÷ MSw/n = F (Test Statistic)
F Crit: The F table requires 2 DF values to determine the Critical Value. Use DF bn and DF w/n.
Purchase answer to see full
attachment
