Reference no: EM131447918
Assignment
The quarterly sales data (number of book sold) for Christian book over the past three years in California follow: You must use Excel to compute the time series (regression) equation
|
Quarter
|
Year1
|
Year2
|
Year3
|
|
1
2
3
4
|
1690
940
2625
2500
|
1800
900
2900
2360
|
1850
1100
2930
2615
|
1. Construct a time series plot. What type of pattern exists in the data?
2. Use the following dummy variables to develop an estimated regression equation to account for any seasonal effects in the data: Quarter1=1 if the sales data point is in Quarter 1, otherwise Quarter 1=0; Quarter 2=1 if the sales data point is in Quarter 2, otherwise, Quarter 2=0; Quarter 3=1 if the sales data point is in Quarter 3, otherwise Quarter 3=0.
3. Compute the quarterly forecasts for next year.
4. Let t=1 to refer to the observation in quarter 1 of year 1; t=2 to refer to the observation in quarter 2 of year 1;,,,,and t=12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part (b) and t, develop an estimated regression equation to account for seasonable effects and any linear trend in the time series. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year.
5. This is an open-ended essay question. Based on the result in 4, what factors might lead to the highest Christian book sales in quarter 3? You may quote bible verses in 2 Corinthians 9:10 or Colossians 1:10.
|
Detailed explanatory note
: Write a detailed explanatory note of the the topic below: (it needs to be 4 bullet points)
|
|
Discuss the influence of culture in ethical decision making
: A human services worker needs to be competent to work with clients from different cultures. There are times when cultural differences between the human services worker and the client influence the final service. For example, suppose a human servic..
|
|
Describe why the change was implemented
: Write a-word paper that addresses the following: Describe why the change was implemented. Explain what impact internal and external influences have on culture and organizational behavior
|
|
Government put in place to regulate safety and efficiency
: What regulations, if any, should the government put in place to regulate the safety and efficiency of product designs distributed for use on 3D printers?
|
|
Compute the quarterly forecasts for next year
: Construct a time series plot. What type of pattern exists in the data? Compute the quarterly forecasts for next year. What factors might lead to the highest Christian book sales in quarter 3?
|
|
Evaluate the current state of the people within organization
: Choose a business you are aware of or can become familiar with. Using your chosen business, evaluate the "current state" of the people within the organization as it relates to processes and technology of the business.
|
|
Living to tell the tale
: An analysis (analytical essay) is not a summary. Though this may seem obvious in theory, it's more difficult in practice. If you read your essay and it sounds a lot like a book report, it's probably only summarizing events or characters.
|
|
How personality theories are relevant your own goal
: Select one of the eight perspectives/approaches to personality development that you find to be in alignment with your own thoughts and opinions. Explain the basics of this perspective/approach. b. Explain why you selected this perspective/approach.
|
|
Mobile app prototyping for the large enterprise
: Explain some of the issues or alternatives in Mobile App Prototyping for the large enterprise. Where does prototyping take place in the software development life cycle (SDLC.) What method would you use to prototype an app for Enterprise use?
|