Question 1
Examine the time series provided in Excel #1a-c to identify the components present (trend, cyclical, seasonal, and/or irregular), with an indication of whether the component seems strong, moderate, or weak. Provide a brief explanation to support your conclusions.
.
Question 2
Explain and contrast the four measures of forecast accuracy.
Question 3
The average SAT verbal score for students from one high school over the last ten exams is 508, 490, 502, 505, 493, 506, 492, 490, 503, 501
Do the scores support an increasing or a decreasing trend? Explain.
Question 4
The number of properties newly listed with a real estate agency in each quarter over the last four years is given below. Assume the time series has seasonality without trend.
|
Year |
||||
|
Quarter |
1 |
2 |
3 |
4 |
|
1 |
73 |
81 |
76 |
77 |
|
2 |
89 |
87 |
91 |
88 |
|
3 |
123 |
115 |
108 |
120 |
|
4 |
92 |
95 |
87 |
97 |
a. Develop the estimated regression equation that minimize the sum of squared error (highest R^2).
.
b. Evaluate the accuracy of that estimated regression equation against known data.
c. Forecast the four quarters of Year 5.
Question 5
A 24-hour coffee/donut shop makes donuts every eight hours. The manager must forecast donut demand so that the bakers have the fresh ingredients they need. Tab #5 contains the actual number of glazed donuts (in dozens) sold in each of the preceding 13 eight-hour shifts. Forecast the demand for glazed donuts for the Day, Evening, and Night shifts of June 8.
Question 6
Quarterly revenues (in $1,000,000’s) for a national restaurant chain for a five-year period are shown in Tab #6 of the Excel file. Forecast the four quarters of year 6.
Question 7
Business at Terry’s Tie Shop can be viewed as falling into three distinct seasons: (1) Christmas (November-December); (2) Father’s Day (late May – mid-June); and (3) all other times. Average weekly sales (in $’s) during each of these three seasons during the past four years is shown in Tab #7 of the Excel file. Forecast sales for the next year.
Question 8
Coyote Cable has been experiencing an increase in cable service subscribers over the last few years due to increased advertising and an influx of new residents to the region. The number of subscribers (in 1000’s) for the last 16 months are shown in Tab #8 of the Excel file. Forecast subscription rates for months 17, 18, 19, 20.
Question 9
Weekly sales of the Weber Dicamatic food processor for the past ten weeks are shown in Tab #9 of the Excel file
a. Determine, on the basis of minimizing the mean square error, select the most appropriate moving average model to use.
b. Forecast sales for week 11 using the model selected in a.
Question 10
Connie Harris, in charge of office supplies at First Capital Mortgage Corp., would like to predict the quantity of paper used in the office photocopying machines per month. She believes that the number of loans originated in a month influence the volume of photocopying performed. She has compiled the following recent monthly data:
|
Number of Loans Originated |
Sheets of Photocopy Paper Used (000s) |
|
25 |
16 |
|
25 |
13 |
|
35 |
18 |
|
40 |
25 |
|
40 |
21 |
|
45 |
22 |
|
50 |
24 |
|
60 |
25 |
a. Develop the regression equation that relates sheets of photocopy paper used to loans originated.
b. Use the regression equation developed in part (a) to forecast the amount of paper used in a month when 70 loan originations are expected.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
Custom Writings Help is a Quality-Oriented Company in Online Writing as a result of hiring exceptional professionals to execute clients' tasks.
Essays
At Custom Writings Help,We understand the struggle of research paper writing, and that is why at Custom WritingS Help, we are all out to help you. We pride ourselves on having a team of clinical writers. The stringent and rigorous vetting process ensures that only the 'BEST' Writers are chosen for the job. We have highly qualified Ph.D. and MA writers working with us; we equally offer these experienced writers specific bonuses and incentives to make them deliver highly original, unique, and informative content at reasonably low prices.
Admissions
Thesis Writing Service
Worlwide, Many Masters Students are struggling with Thesis Completion. A thesis is likely to be the longest and most challenging piece of work a student has ever completed. However, unlike essays and other assignments, a student can pick a particular interest topic and work on their initiative. Fortunately, we are there for you. At Custom Writings Help, you are assured of an authentic, imaginative, informative, linguistically great, and advantageous thesis that adheres to all your needs. So, why continue considering different writers when you have discovered the best in the field?
Editing
Custom Papers
Not a single student can avoid writing custom papers. However, a total lack of experience, skills, and time makes it very hard to produce a superb writing piece. Therefore, if you are seeking professional help, turn to us. Our specialized and experienced writers compose a variety of model papers, including custom essays, college term papers, research papers, book reports, MBA essays, executive summaries, dissertations, Ph.D. theses, admission essays, and research proposals for college and university students at any level.
Coursework
Essay Writing
Most of the students disregard the critical principles of essay writing and compose papers below sensible guidelines. Therefore, with Custom Writings Help, one should not worry about his/her essay. Our Writers compose informative and engaging content on all complexities and topics. We write meaningful and smart essays while prioritizing all aspects that bring about a good grade, such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines.
Coursework
Coourse Work Writing
Don't let the seemingly never-ending onslaught of writing assignments get you down. If you are looking where to get course work assistance online, the writers at Custom Writings Help are here to assist you with all of your writing needs. We undertake to unique delivery of papers that meet the professor's requirements. The content is proofread, edited, and checked plagiarism before submission to customers. No matter how big or small your work is, we will deliver on time. Try US Now! !
Coursework
Dissertation Writing Service
High-Quality Dissertation Writing Services are rare. They require Ph.D. academicians – not easily found. However, are an exception. The years, time, and resources we have invested in the dissertation world has given us a competitive advantage over others. Choose to come to Custom Writings Help; You will find perfect Ph.D. consultants who have written hundreds of dissertations theses ready to help you. Let our dissertation-writing services help you craft your dissertation, for you are assured we will give you the results.