Scatter plot of advertsing as the independent and sales
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?