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. Categories—the individual sample names
3. Criterion Variable—the variable being tested/compared (other name: Variable of Interest)
4. SStotal—total variation for all data points and all samples (SS = Sum of the Squares)
5. SSbetween—variation due to the classification variable (SS = Sum of the Squares)
6. SSwithin—variation due to chance (SS = Sum of the Squares)
7. Sum of the Squares—the 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