Question: Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019?

Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast of the demand in the next 3 years? [20 marks] c. Does the forecast follow seasonality? [5 marks] 2. Create a forecast using the excel built-in feature for the sales in the 12 months of 2017 for the data set provided similar to question 1. Take confidence as 95%. Choose seasonality as 12 months. Add a trendline that best fits the data with the least error using the R2 method. [Total - 15 marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

prepare a report for the director of the Daycare Center that discusses the opportunities for improvement and provides general suggestions of how the Daycare Center's financial situation could be...

Imagine that you have decided you need a new car, but not any car will do; you have decided to purchase the car of your dreams. Conduct some research as to the cost of this car. You have determined...

1. Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast of the demand in...

1. Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast for the demand in...

GIVIISI V. Common Size Income Statement Prepare a common size income statement for two years and compare/contrast the changes (Refer to chapter 17) VI. Ratio Analysis of Financial Statements Prepare...

Plasma Pathology has incurred the following costs in its diagnostic blood laboratory during the past 12 months: Month Number of blood test completed Cost January 6100 $90000 February 5300 87000 March...

Hi, I need help with a statistics assignment related to excel. Properties sold in Melboune Property Location 3 1 8 1 28 1 29 1 30 1 31 1 34 1 37 1 45 1 47 1 51 1 54 1 55 1 56 1 57 1 58 1 60 1 61 1 62...

my questions Exercise 13.5 (Hard) Tammy lives for two periods. In the first period of life she works ` hours at a wage of w per hour. In the second period of life she is retired and supplies no...

oalll Question: Put together a portfolio of work documents you have drafted and written. If you are working you can use actual workplace documents, with identifying names redacted. Do not include any...

You want to know how the commuting time of your employees compares to Departments competing for the same staff, so you get some survey data on average commuting times for 25 randomly selected people...

You have just completed a regression study in which you are attempting to link weekly sales of SeaFarers new sun block spray to three factors: price, advertising and use of a special point of...

How do most organizations react to the low - income consumer market? a . They ignore it since these consumers have almost no discretionary income. b . Many organizations have studied this market, but...

1. A patent increases the incentive to develop new products because it ________ the price of the product and thus generates profit to cover a firms costs of _______. 2. In some cases, a patent is...

Which owner has the largest producer surplus when the price of a ride is $17.50? Explain. The table gives the supply schedules for jet-ski rides by the only suppliers: Rick, Sam, and Tom. Quantity...

Identify the types of accounts (assets, liabilities, and so on) debited and credited for each of the five types of adjusting entries.

A firm has sales of $3 million, and 10 percent of the sales are for cash. The year-end accounts receivable balance is $285,000. What is the average collection period? (Use a 360-day year.)

1. A monopoly is inefficient solely because the monopolist gets a profit at the expense of consumers. ____________ (True/False) 2. To show the deadweight loss from monopoly, we compare the monopoly...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

APV For the company in the previous problem, what is the value of being able to issue subsidized debt instead of having to issue debt at the terms it would normally receive? Assume the face amount...

What is the adjusted present value of this project? LO.1

WACC Bolero, Inc., has compiled the following information on its financing costs: Type of Financing Book Value Market Value Cost Long-term debt $ 2,000,000 $ 2,000,000 3.5% Short-term debt 9,000,000...