stats disc8
The following problems are from the above textbook Chapter 13 for this course as Discussion Questions assignment for week eight: You can use any source.
1. 13.1 Fitting a straight line to a set of data yiedls the following prediction line: Y, = 2 + 5 Xi
a. Interpret the meaning of the Y intercept, bo.
b. Interpret the meaning of the slope, b1.
c. Predict the value fo Y for X = 3.
2. Following data is amount of advertising an organization spent for sales. The second column represents the resultant sales. Use excel to ….
a. Obtain a Scatter plot of advertsing as the independent and sales as the dependent variable.
b. Note the linear regression Model
c. Predict the amount of sales for $2000 advertising commercial.
|
Advertisement ($'000) |
Sales ($'000) |
|
1068 |
4489 |
|
1026 |
5611 |
|
767 |
3290 |
|
885 |
4113 |
|
1156 |
4883 |
|
1146 |
5425 |
|
892 |
4414 |
|
938 |
5506 |
|
769 |
3346 |
|
677 |
3673 |
|
1184 |
6542 |
|
1009 |
5088 |
3. Analysis of Variance
Is there a statistical significance difference between the five supervisors? How about the different shifts? (conduct an analysis of variance using excel to determine this problem. Make sure you conuct a full fledge eight step hypotheis test for both supervisors and shifts.)
|
|
Day Shift |
Evening Shift |
Midnight shift |
|
Joe |
22 |
21 |
23 |
|
Bil |
23 |
26 |
33 |
|
Robert |
24 |
25 |
32 |
|
Sally |
32 |
24 |
42 |
|
Zoe |
35 |
29 |
39 |
For the supervisors:
3a What will be your Ho?
3b what is your Ha?
3c What is your level of significance?
3d What is your test statistics?
3e Why did you use the specific test statistics?
3f What is your decision rule?
3g Do your excel statistical print out
3h What is your decision?
3i What is your conclusion?
3K What is your recommendation?
For the Shifts:
3a What will be your Ho?
3b what is your Ha?
3c What is your level of significance?
3d What is your test statistics?
3e Why did you use the specific test statistics?
3f What is your decision rule?
3g Do your excel statistical print out
3h What is your decision?
3i What is your conclusion?
3K What is your recommendation?