Question

In: Statistics and Probability

Quarter Enrollments in Business Statistics course at a major university are given in the EXCEL worksheetEnrollment:...

Quarter Enrollments in Business Statistics course at a major university are given in the EXCEL worksheetEnrollment:

  1. Develop an additive model for trend and seasonality. Please clearly define your variables.

b. Use the additive model to forecast for the enrollments for Fall 2013, Winter 2014, and Spring 2014.

Quarter Enrollment
2009 Fall 705
2010 Winter 734
Spring 661
Fall 760
2011 Winter 780
Spring 700
Fall 863
2012 Winter 860
Spring 750
Fall 880
2013 Winter 900
Spring 780

Please show step by step instructions using excel:

Solutions

Expert Solution

Answer:

2014 Fall 898.685
Winter 902.046
Spring 791.769
Year Season Enrollment Sum of 3s Sum of 2 3s Trend Ts-T SV Forecast
2009 Fall 705
2010 Winter 734
Spring 661 2155 4356 726.000 -65.000
Fall 760 2201 4441 740.167 19.833
2011 Winter 780 2240 4583 763.833 16.167
Spring 700 2343 4766 794.333 -94.333 Trend
Fall 863 2423 4896 816.000 47.000 Last 31.66667
2012 Winter 860 2473 4963 827.167 32.833 First 0
Spring 750 2490 5020 836.667 -86.667 Change 31.66667
Fall 880 2530 5090 848.333 31.667 Average Change 3.958333
2013 Winter 900 2560 852.292 47.708
Spring 780 856.250
2014 Fall 860.208 38.477 898.685
Winter 864.167 37.880 902.046
Spring 868.125 -76.356 791.769
Variation Fall Winter Spring
19.833 16.167 -65.000
47.000 32.833 -94.333
31.667 47.708 -86.667 Sum Average
Average Variation 32.833 32.236 -82.000 -16.931 -5.644
Adjusted Variation 38.477 37.880 -76.356 0.000

orchestra answered 1 year ago
Next > < Previous

Related Solutions

Quarter Enrollments in Business Statistics course at a major university are given in the EXCEL worksheet...
Quarter Enrollments in Business Statistics course at a major university are given in the EXCEL worksheet Enrollment: Develop an additive model for trend and seasonality. Please clearly define your variables. b. Use the additive model to forecast for the enrollments for Fall 2013, Winter 2014, and Spring 2014. Quarter Enrollment 2009 Fall 705 2010 Winter 734 Spring 661 Fall 760 2011 Winter 780 Spring 700 Fall 863 2012 Winter 860 Spring 750 Fall 880 2013 Winter 900 Spring 780 Please...
State University offers several sections of a Business Statistics course in an in-class and online format....
State University offers several sections of a Business Statistics course in an in-class and online format. Both formats are administered the same final exam each year. You have been assigned to test the hypothesis that the average final exam score of in-class students is different from the average final exam score of online students. The following data summarizes the sample statistics for the final exam scores for students from each format. Assume that the population variances are unequal. In-class Format...
A random sample of 12 second-year university students enrolled in a business statistics course was drawn....
A random sample of 12 second-year university students enrolled in a business statistics course was drawn. At the course's completion, each student was asked how many hours he or she spent doing homework in statistics. The data are listed below. 40, 41, 29, 30, 31, 31, 34, 29, 37, 41, 37, 40 It is known that the population standard deviation is 8. The instructor has recommended that students devote 3 hours per week for the duration of the 12-week semester,...
A random sample of 12 second-year university students enrolled in a business statistics course was drawn....
A random sample of 12 second-year university students enrolled in a business statistics course was drawn. At the course's completion, each student was asked how many hours he or she spent doing homework in statistics. The data are listed below. 281726262620292823271820282626292318172620282720 It is known that the population standard deviation is 9. The instructor has recommended that students devote 2 hours per week for the duration of the 12-week semester, for a total of 24 hours. Test to determine whether there...
A random sample of 12 second-year university students enrolled in a business statistics course was drawn....
A random sample of 12 second-year university students enrolled in a business statistics course was drawn. At the course’s completion, each student was asked how many hours he or she spent doing homework in statistics. The data are listed here. It is know that the population standard deviation is 8. The instructor has recommended that the students devote 36 hours to the course for the semester. Test to determine at the 1% significance level whether there is evidence that the...
A random sample of 12 second-year university students enrolled in a business statistics course was drawn....
A random sample of 12 second-year university students enrolled in a business statistics course was drawn. At the course's completion, each student was asked how many hours he or she spent doing homework in statistics. The data are listed below. 28 18 15 20 14 25 21 29 20 23 24 26 It is known that the population standard deviation is 6. The instructor has recommended that students devote 2 hours per week for the duration of the 12-week semester,...
Students enrolled in an introductory statistics course at a university were asked to take a survey...
Students enrolled in an introductory statistics course at a university were asked to take a survey that indicated whether the student’s learning style was more visual or verbal. Each student received a numerical score ranging from -11 to +11. Negative scores indicated a visual learner, and positive scores indicated a verbal learner. The closer the score was to -11 or +11, the stronger the student’s inclination toward that learning style. A score of 0 would indicate neutrality between visual or...
Students enrolled in an introductory statistics course at a university were asked to take a survey...
Students enrolled in an introductory statistics course at a university were asked to take a survey that indicated whether the student’s learning style was more visual or verbal. Each student received a numerical score ranging from -11 to +11. Negative scores indicated a visual learner, and positive scores indicated a verbal learner. The closer the score was to -11 or +11, the stronger the student’s inclination toward that learning style. A score of 0 would indicate neutrality between visual or...
Students enrolled in an introductory statistics course at a university were asked to take a survey...
Students enrolled in an introductory statistics course at a university were asked to take a survey that indicated whether the student’s learning style was more visual or verbal. Each student received a numerical score ranging from -11 to +11. Negative scores indicated a visual learner, and positive scores indicated a verbal learner. The closer the score was to -11 or +11, the stronger the student’s inclination toward that learning style. A score of 0 would indicate neutrality between visual or...
. A teaching assistant for Statistics course as a university collected data from students in her...
. A teaching assistant for Statistics course as a university collected data from students in her class to investigate whether study time per week (average number of hours) differed between students who planned to go to graduate school and those who did not. The data were as follows: Graduate school: 15, 7, 15, 10, 5, 5, 2, 3, 12, 16, 15, 37, 8, 14, 10, 18, 3, 25, 15, 5, 5 No graduate school: 6, 8, 15, 6, 5, 14,...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT