Question

In: Statistics and Probability

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:

  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:

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"..


Related Solutions

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: 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...
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
ADVERTISEMENT
ADVERTISEMENT