W8 Homework graded
docx
keyboard_arrow_up
School
American Military University *
*We aren’t endorsed by this school
Course
302
Subject
Business
Date
Jan 9, 2024
Type
docx
Pages
18
Uploaded by workouthypex
Attempt Score
18 / 20 - 90 %
Overall Grade (Highest Attempt)
18 / 20 - 90 %
stion 1
1 / 1 p
A college prep school advertises that their students are more prepared to succeed in college than other schools. To verify this, they categorize GPA's into 4 groups and look up the proportion of students at a state college in each category. They find that 7% have a 0-0.99, 21% have a 1-1.99, 37% have a 2-2.99, and 35% have a 3-4.00 in GPA.
They then take a random sample of 200 of their graduates at the state college and find that 19 has a 0-0.99, 28 have a 1-
1.99, 82 have a 2-2.99, and 71 have a 3-4.00.
Can they conclude that the grades of their graduates are distributed differently than the general population at the school? Test at the 0.05 level of significance.
Enter the test statistic - round to 4 decimal places.
Test statistic:___
___
Answer:
7.3315
Hide question 1 feedback
0-0.99
1-1.99
2-2.99
3-4.00
Observed Counts
19
28
82
71
Expected Counts
=200*0.07 =14
=200*.21
= 42
=200*.37
= 74
=200*.35
= 70
Test Stat = (19−14)214+(28−42)242+(82−74)274+(71−70)270
Test Stat = 7.331532
n 2
1
A company manager believes that a person's ability to be a leader is directly correlated to their zodiac sign. He never selects someone to chair a committee without first evaluating their zodiac sign. An irate employee sets out to prove her manager wrong. She claims that if zodiac sign truly makes a difference in leadership, then a random sample of 210 CEO's in our country would reveal a difference in zodiac sign distribution. She finds the following zodiac signs for her random sample of 210 CEO's:
Births
Signs
25
Aries
13
Taurus
17
Gemini
21
Cancer
16
Leo
18
Virgo
15
Libra
16
Scorpio
20
Sagittarius
11
Capricorn
23
Aquarius
15
Pisces
Can she conclude that zodiac sign makes a difference in whether or not a person makes a good
leader?
Enter the
p
-value - round to 4 decimal places. Make sure you put the 0 in front of the decimal.
p
-value = ___
___
Answer:
0.4798
Hide question 2 feedback
The Expected Count is all the same value. 210*(1/12) = 17.5
Births
Signs
Expected Count
25
Aries
17.5
13
Taurus
17.5
17
Gemini
17.5
21
Cancer
17.5
16
Leo
17.5
18
Virgo
17.5
15
Libra
17.5
16
Scorpio
17.5
20
Sagittariu
s
17.5
11
Capricorn
17.5
23
Aquarius
17.5
15
Pisces
17.5
Use Excel to find the p-value
=CHISQ.TEST(Highlight Observed, Highlight Expected)
n 3
1 A large department store is curious about what sections of the
store make the most sales. The manager has data from ten years prior that show 30% of sales come from Clothing, 25% Home Appliances, 18% Housewares, 13% Cosmetics, 12% Jewelry, and 2% Other.
In a random sample of 550 current sales, 188 came from Clothing, 153 Home Appliances, 83 Housewares, 54 Cosmetics, 61 Jewelry, and 11 Other. At α=0.10, can the manager conclude that the distribution of sales among the departments has changed?
Enter the test statistic - round to 4 decimal places.
Test statistic =___
___
Answer:
12.2012
Hide question 3 feedback
Clothing
Home App.
Housewares
Cosmetics
Jewelry
Other
Observed
Counts
188
153
83
54
61
11
Expected Counts
550*.30 = 165
550*.25 = 137.5
550*.18 = 99
550*.13 = 71.5
550*.12 = 66
550*.02= 11
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Test Stat = (188−165)2165+(153−137.5)2137.5+(83−99)299+(54−71.5)271.5+(61−66)266+(11−11)211
n 4
1 A company that develops over-the-counter medicines is working on a new product that is meant to shorten the length of sore throats. To test their product for effectiveness, they take a random sample of 110 people and record how long it took for their symptoms to completely disappear. The results are in the table below. The company knows that on average (without medication) it takes a sore throat 6 days or less to heal 42% of the time, 7-9 days 31% of the time, 10-12 days 16% of the time, and 13 days or more 11% of the time.
Can it be concluded at the 0.01 level of significance that the patients who took the medicine healed at a different rate than these percentages? After running a Goodness of Fit test, can it
be concluded that there is a statistically significant difference in duration of a sore throat for those that took the medicine and what is the p-value?
6 days or less
7-9 days
10-12 days
13 or more days
Duration of
Sore Throat
49
40
12
9
Expected
Counts
46.2
34.1
17.6
12.1
Yes, the p-value = 0.287801
No, the p-value = 0.712199
Yes, the p-value = 0.712199
No, the p-value = 0.287801
Hide question 4 feedback
Use Excel to find the p-value you have the Observed and Expected Counts you can use
=CHISQ.TEST( Highlight Observed Counts, Highlight Expected Counts) = 0.287801
0.287801 > .01, Do Not Reject Ho. No, this is not significant.
n 5
1 A Driver's Ed program is curious if the time of year has an impact on number of car accidents in the U.S. They assume that weather may have a significant impact on the ability of drivers to control their vehicles. They take a random sample of
150 car accidents and record the season each occurred in. They found that 27 occurred in the Spring, 39 in the Summer, 31 in the Fall, and 53 in the Winter. Can it be concluded at the
0.05 level of significance that car accidents are not equally distributed throughout the year?
Enter the test statistic - round to 2 decimal places.
Test statistic=___
___
Answer:
10.53
Hide question 5 feedback
Spring
Summer Fall
Winter
Observed Counts
27
39
31
53
Expected Counts
150*.25 = 37.5
150*.25 = 37.5
150*.25 = 37.5
150*.25=
37.5
Test Stat = (27−37.5)237.5+(39−37.5)237.5+(31−37.5)237.5+(53−37.5)237.5
n 6
1 A color code personality test categorizes people into four colors – Red (Power), Blue (Intimacy), Green (Peace), and Yellow (Fun). In general, 25% of people are Red, 35% Blue, 20% Green, and 20% Yellow. An art class of 45 students is tested at a university and 7 are found to be Red, 18 Blue, 9 Green, and 11 Yellow.
Can it be concluded that personality type has an impact on students' areas of interest and talents, such as artistic
students and state the p-value? Test at a 0.05 level of significance.
Red
Blue
Green
Yellow
Observed
Counts
7
18
9
11
Expected
Counts
11.25
15.75
9
9
Yes, the p-value = 0.501025
No, the p-value = 0.501025
No, the p-value = 0.498975
Yes, the p-value = 0.498975
Hide question 6 feedback
Use Excel to find the p-value you have the Observed and Expected Counts you can use
=CHISQ.TEST( Highlight Observed Counts, Highlight Expected Counts) = 0.498975
0.498975 > .05, Do Not Reject Ho. No, this is not significant.
Use Excel to find the p-value you have the Observed and Expected Counts you can use
=CHISQ.TEST( Highlight Observed Counts, Highlight Expected Counts) = 0.498975
0.498975 > .05, Do Not Reject Ho. No, this is not significant.
n 7
1 Students at a high school are asked to evaluate their experience in the class at the end of each school year. The courses are evaluated on a 1-4 scale – with 4 being the best experience possible. In the History Department, the courses typically are evaluated at 10% 1's, 15% 2's, 34% 3's, and 41%
4's.
Mr. Goodman sets a goal to outscore these numbers. At the end of the year he takes a random sample of his evaluations and finds 10 1's, 13 2's, 48 3's, and 52 4's. At the 0.05 level of
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
significance, can Mr. Goodman claim that his evaluations are significantly different than the History Department's?
yes, the p-value = 0.5893
no, the p-value = 0.5893
no, the p-value = 0.3913
yes, the p-value = 0.3913
Hide question 7 feedback
1's
2's
3's
4's
Observed Counts
10
13
48
52
Expected Counts
123 *.10 = 12.3
123*.15 = 18.45
123*.34 = 41.82
123*.41 = 50.43
Use Excel to find the p-value
=CHISQ.TEST(Highlight Observed, Highlight Expected)
p-value > .05, Do Not Reject Ho. No, this is not significant.
n 8
1 Pamplona, Spain is the home of the festival of San Fermin – The Running of the Bulls. The town is in festival mode for a week and a half every year at the beginning of July. There is a running joke in the city, that Pamplona has a baby boom every April – 9 months after San Fermin. To test this claim, a resident takes a random sample of 300 birthdays from native residents and finds the following
observed counts
:
January
25
February
25
March
27
April
26
May
21
June
26
July
22
August
27
September
21
October
26
November
28
December
26
At the 0.05 level of significance, can it be concluded that births in Pamplona are not equally distributed throughout the 12 months of the year?
Hypotheses:
H
0
: Births in Pamplona ______ equally distributed throughout the year.
H
1
: Births in Pamplona ______ equally distributed throughout the year.
Select the best fit choices that fit in the two blank spaces above.
are, are not
are not, are
are, are
are not, are not
Question 9
0 / 1
point
A public opinion poll surveyed a simple random sample of 550 voters in Oregon. The respondents were asked which political party they identified with most and were categorized by residence. Results are shown below. Decide if voting preference is independent from location of residence. Let
α=0.05
.
Republican
Democrat
Independent
NW Oregon
85
103
22
SW Oregon
45
66
10
Central Oregon
46
53
9
Eastern Oregon
67
33
11
Enter the test statistic - round to 4 decimal places.
Answer:
0.0060
(18.0789)
Hide question 9 feedback
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table. Next you need to sum the rows and columns. Once you have those you need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
Republican
Democrat
Independent
Sum
NW Oregon
85
103
22
210
SW Oregon
45
66
10
121
Central Oregon
46
53
9
108
Eastern Oregon
67
33
11
111
Sum
243
255
52
550
Republican
Democrat
Independent
NW Oregon
=243*(210/550)
=255*(210/550)
=52*(210/550)
SW Oregon
=243*(121/550)
=255*(121/550)
=52*(121/550)
Central Oregon
=243*(108/550)
=255*(108/550)
=52*(108/550)
Eastern Oregon
=243*(111/550)
=255*(111/550)
=52*(111/550)
Now that we calculated the Expected Counts we need to find the Test Statistic.
Test Stat = (85−92.781818)292.781818+(45−53.46)253.46+...+(11−10.494545)210.494545
You will need to use all 12 Count values but I am only showing you 3 because there isn't room to write out the entire equation.
n 10
1 A manufacturing company knows that their machines produce parts that are defective on occasion. They have 4 machines producing parts, and want to test if defective parts are dependent on the machine that produced it. They take a random sample of 321 parts and find the following results. Test at the 0.05 level of significance.
Machine 1
Machine 2
Machine 3
Machine 4
Defective
10
15
16
9
Non-Defective
72
75
66
58
Can it be concluded that number of defective parts is dependent on machine?
Yes, it can be concluded concluded that number of defective parts is dependent on machine because the p-value = 0.4264.
No, it cannot be concluded concluded that number of defective parts is dependent on machine because the p-value = 0.4264.
Yes, it can be concluded concluded that number of defective parts is dependent on machine because the p-value = 0.5736.
No, it cannot be concluded concluded that number of defective parts is dependent on machine because the p-value = 0.5736.
Hide question 10 feedback
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table. Next you need to sum the rows and columns. Once you have those you need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
Machine 1
Machine 2
Machine 3
Machine 4
Sum
Defective
10
15
16
9
50
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Non-Defective
72
75
66
58
271
Sum
82
90
82
67
321
Machine 1
Machine 2
Machine 3
Machine 4
Defective
=82*(50/321)
=90*(50/321)
=82*(50/321)
=67*(50/321)
Non-Defective
=82*(271/321) =90*(271/321)
=82*(271/321) =67*(271/321)
Now that we calculated the Expected Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.5736
0.5736 > 0.05, Do Not Reject Ho. No, it cannot be concluded concluded that number of defective parts is dependent on machine.
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table. Next you need to sum the rows and columns. Once you have those you need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
Machine 1
Machine 2
Machine 3
Machine 4
Sum
Defective
10
15
16
9
50
Non-Defective
72
75
66
58
271
Sum
82
90
82
67
321
Machine 1
Machine 2
Machine 3
Machine 4
Defective
=82*(50/321)
=90*(50/321)
=82*(50/321)
=67*(50/321)
Non-Defective
=82*(271/321) =90*(271/321)
=82*(271/321) =67*(271/321)
Now that we calculated the Expected Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.5736
0.5736 > 0.05, Do Not Reject Ho. No, it cannot be concluded concluded that number of defective parts is dependent on machine.
n 11
1 The following sample was collected during registration at a large middle school. At the 0.05 level of significance, can it be concluded that level of math is dependent on grade level?
Honors Math
Regular Math
General Math
6
th
Grade
35
47
14
7
th
Grade
37
49
12
8
th
Grade
33
48
19
Enter the missing values in the expected matrix - round to 4 decimal places.
Honors Math
Regular Math
General Math
6
th
Grade
___
___
___
7
th
Grade
35
48
15
8
th
Grade
___
___
___
___
Answer for blank # 1:
34.2857
(16.67 %)
Answer for blank # 2:
47.0204
(16.67 %)
Answer for blank # 3:
14.6939
(16.67 %)
Answer for blank # 4:
35.7143
(16.67 %)
Answer for blank # 5:
48.9796
(16.67 %)
Answer for blank # 6:
15.3061
(16.67 %)
Hide question 11 feedback
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table. We need to calculate the Expected Counts. Then sum up the rows and column. You need to find the probability of the row and then multiple it by
the column total.
Honors Math
Regular Math
General Math
Sum
6th Grade
35
47
14
96
7th Grade
37
49
12
98
8th Grade
33
48
19
100
Sum
105
144
45
294
Honors Math
Regular Math
General Math
6th Grade
=105*(96/294) =144*(96/294) =45*(96/294)
7th Grade
=105*(98/294) =144*(98/294) =45*(98/294)
8th Grade
=105*(100/294)
=144*(100/294
)
=45*(100/294)
n 12
1 A high school runs a survey asking students if they participate in sports. The results are found below. Run an independence test for the data at
α=0.01
.
Freshmen
Sophomores
Juniors
Seniors
Yes
75
88
55
42
No
30
28
38
40
Enter the test statistic - round to 4 decimal places.
Answer:
16.2406
Hide question 12 feedback
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table. Next you need to sum the rows and columns. Once you have those you need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
Freshmen
Sophomores
Juniors
Seniors
Yes
75
88
55
42
No
30
28
38
40
Sum
105
116
93
82
Freshmen
Sophomores
Juniors
Seniors
Yes
=105*(260/396)
=116*(260/396)
=93*(260/396)
=82*(260/396)
No
=105*(136/396)
=116*(136/396)
=93*(136/396)
=82*(136/396)
Now that we calculated the Expected Counts we need to find the Test Statistic.
Test Stat = (75−68.9393)268.9393+(30−36.0606)236.0606+...+(40−28.1616)228.1616
You will need to all 8 Count values but I am only showing you 3 because there isn't room to write out the entire equation.
n 13
1 An electronics store has 4 branches in a large city. They are curious if sales in any particular department are different depending on location. They take a random sample of 4 purchases throughout the 4 branches – the results are recorded below. Run an independence test for the data below at the 0.05 level of significance.
Appliances
TV
Computers
Cell Phones
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Branch 1
56
28
63
24
Branch 2
44
22
55
27
Branch 3
53
17
49
33
Branch 4
51
31
66
29
Can it be concluded that sales in the various departments are dependent on branch?
Yes, it can be concluded that sales in the various departments are dependent on branch because
the p-value = 0.6099
No, it cannot be concluded that sales in the various departments are dependent on branch because the p-value = 0.6099
No, it cannot be concluded that sales in the various departments are dependent on branch because the p-value = 0.3901
Yes, it can be concluded that sales in the various departments are dependent on branch because
the p-value = 0.3901
Hide question 13 feedback
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table. Next you need to sum the rows and columns. Once you have those you need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
Appliances
TV
Computers
Cell Phones
Branch 1
56
28
63
24
Branch 2
44
22
55
27
Branch 3
53
17
49
33
Branch 4
51
31
66
29
Sum
204
98
233
113
Appliances
TV
Computers
Cell Phones
Branch 1
=204*(171/648)
=98*(171/648)
=233*(171/648)
=113*(171/648)
Branch 2
=204*(148/648)
=98*(148/648)
=233*(148/648)
=113*(148/648)
Branch 3
=204*(152/648)
=98*(152/648)
=233*(152/648)
=113*(152/648)
Branch 4
=204*(177/648)
=98*(177/648)
=233*(177/648)
=113*(177/648)
Now that we calculated the Expected Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.6099
0.6099 > 0.05, Do Not Reject Ho. No, it cannot be concluded that sales in the various departments are dependent on branch.
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You
are given the Observed Counts in the table. Next you need to sum the rows and columns. Once you have those you need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
Appliances
TV
Computers
Cell Phones
Branch 1
56
28
63
24
Branch 2
44
22
55
27
Branch 3
53
17
49
33
Branch 4
51
31
66
29
Sum
204
98
233
113
Appliances
TV
Computers
Cell Phones
Branch 1
=204*(171/648)
=98*(171/648)
=233*(171/648)
=113*(171/648)
Branch 2
=204*(148/648)
=98*(148/648)
=233*(148/648)
=113*(148/648)
Branch 3
=204*(152/648)
=98*(152/648)
=233*(152/648)
=113*(152/648)
Branch 4
=204*(177/648)
=98*(177/648)
=233*(177/648)
=113*(177/648)
Now that we calculated the Expected Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.6099
0.6099 > 0.05, Do Not Reject Ho. No, it cannot be concluded that sales in the various departments are dependent on branch.
n 14
1 A high school runs a survey asking students if they participate in sports. The results are found below. Run an independence test for the data at
α=0.01
.
Freshmen
Sophomores
Juniors
Seniors
Yes
75
88
55
42
No
30
28
38
40
Can it be concluded that participation in sports is dependent on grade level?
No, it cannot be concluded that participation in sports is dependent on grade level because the p-value = 0.0010.
No, it cannot be concluded that participation in sports is dependent on grade level because the p-value = 0.0020.
Yes, it can be concluded that participation in sports is dependent on grade level because the p-
value = 0.0020.
Yes, it can be concluded that participation in sports is dependent on grade level because the p-
value = 0.0010.
Hide question 14 feedback
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table. Next you need to sum the rows and columns. Once
you have those you need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
Freshmen
Sophomores
Juniors
Seniors
Yes
75
88
55
42
No
30
28
38
40
Sum
105
116
93
82
Freshmen
Sophomores
Juniors
Seniors
Yes
=105*(260/396)
=116*(260/396)
=93*(260/396)
=82*(260/396)
No
=105*(136/396)
=116*(136/396)
=93*(136/396)
=82*(136/396)
Now that we calculated the Expected Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.0010
0.0010 < .01,Reject Ho. Yes, it can be concluded that participation in sports is dependent on grade level.
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table. Next you need to sum the rows and columns. Once you have those you need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
Freshmen
Sophomores
Juniors
Seniors
Yes
75
88
55
42
No
30
28
38
40
Sum
105
116
93
82
Freshmen
Sophomores
Juniors
Seniors
Yes
=105*(260/396)
=116*(260/396)
=93*(260/396)
=82*(260/396)
No
=105*(136/396)
=116*(136/396)
=93*(136/396)
=82*(136/396)
Now that we calculated the Expected Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.0010
0.0010 < .01,Reject Ho. Yes, it can be concluded that participation in sports is dependent on grade level.
n 15
1 You are conducting a study of three types of feed supplements for cattle to test their effectiveness in producing weight gain among calves whose feed includes one of the supplements. You have four groups of 30 calves (one is a control group receiving the usual feed, but no supplement). You will conduct a one-way ANOVA after one year to see if there are difference in the mean weight for the four groups.
What is
k
for this experiment?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
120
30
3
4
Hide question 15 feedback
k is the number of groups
n 16
1 You are conducting a study of three types of feed supplements for cattle to test their effectiveness in producing weight gain among calves whose feed includes one of the supplements. You have four groups of 30 calves (one is a control group receiving the usual feed, but no supplement). You will conduct a one-way ANOVA after one year to see if there are difference in the mean weight for the four groups.
If
SS
within
= 366.5 and
SS
total
= 627.9 for this data.
Identify the
SS
between
261.4
3
30
994.4
255.4
Hide question 16 feedback
SS
total
=
SS
within
+
SS
between
627.9 = 366.5 +
SS
between
n 17
1 The
F
Statistic from an experiment with
k
= 4 and
n
= 100 is 4.72. At
α
= 0.01, will you reject
the null hypothesis?
No
Yes
Hide question 17 feedback
Use Excel to find the p-value
df
1
= k - 1 = 4-1 = 3
df
2
= n - k = 100 - 4 = 96
=F.DIST.RT(4.72,3,96) = 0.004076343
0.004076343 < .01, Reject Ho, Yes, this is significant.
n 18
0 If the number of degrees of freedom for a chi-square distribution is 25, what is the standard deviation? Round to four decimal places.
Standard Deviation=___
___
Answer: 7.0710
(7.0711)
View question 18 feedback
n 19
1 Staples, a chain of large office supply stores, sells a line of desktop and laptop computers. Company executives want to know whether the demands for these two types of computers are dependent on one another. Each day's demand for each type of computers is categorized as Low, Medium-Low, Medium-High, or High. The data shown in the table below is based on 205 days of operation. Based on these data, can ? Test at the 5% level of significance.
desktops
low
med-low
med-high
high
low
4
15
14
3
36
laptops
med-low
6
18
18
23
65
med-high
13
17
10
17
57
high
7
15
15
10
47
30
65
57
53
205
What is the test value for this hypothesis test?
Answer: ___ Round your answer to two decimal places.
What is the critical value for this hypothesis test?
Answer: ___ Round your answer to two decimal places.
What is the conclusion for this hypothesis test? Choose one.
1. At the .05 level of significance, Staples can conclude
that demands for these two types of computers are independent.
2. At the .05 level of significance, Staples can conclude
that
demands for these two types of computers are dependent.
Answer: ___ Enter only a 1 or 2 for your answer.
Answer for blank # 1:
17.05
(33.33 %)
Answer for blank # 2:
16.92
(33.33 %)
Answer for blank # 3:
2
(33.33 %)
Hide question 19 feedback
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given the Observed Counts in the table and the rows and columns are already summed for you. We need to calculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.
low
med-low
med-high
high
low
=30*(36/205)
=65*(36/205)
=57*(36/205)
=53*(36/205)
med-low
=30*(65/205)
=65*(65/205)
=57*(65/205)
=53*(65/205)
med-high
=30*(57/205)
=65*(57/205)
=57*(57/205)
=53*(57/205)
high
=30*(47/205)
=65*(47/205)
=57*(47/205)
=53*(47/205)
Now that we calculated the Expected Counts we need to find the Test Statistic.
Test Stat = (4−5.26829)25.26829+(6−9.512195)29.512195+...+(10−12.151219)212.151219
You will use this equation to find the Test Stat. You will need to all 16 Count values but I am only showing you 3 because there isn't room to write out the entire equation.
To find the Chi-Square Critical Value use =CHISQ.INV.RT( ) function in Excel. The probability is .05 and df = (4-1)*(4- 1) = 9. =CHISQ.INV.RT(.05,9) = 16.92
17.05 > 16.92. The Test Stat is greater than the Critical Value. Reject Ho. This is significant and enough evidence that Staples conclude that demands for these two types of computers are dependent.
n 20
1 The number of degrees of freedom for a test of independence is equal to:
The sample size plus one
(number of columns - 1)(number of rows - 1)
The sample size minus one
Done
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,

Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,