jeremyrs101
29.01.2021 •
Business
The demand for toys produced by the Miki Manufacturing Company has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop simple linear regression forecast and answer the following questions.
Simple Linear Regression Forecast
Period Actual Demand Forecast Formulas
1 1,600 #N/A
2 2,000 #N/A
3 1,800 #N/A
4 1,200 #N/A
5 2,300 #N/A
6 3,600 #N/A
7 3,300 #N/A
8 3,200 #N/A
9 4,000 #N/A
10 4,900 #N/A
11 4,500 #N/A
12 4,400 #N/A
13 #N/A
Intercept #N/A
Slope #N/A
1. What is the trend line? Round your answers to two decimal places. Do not round intermediate calculations.
2. Calculate the linear trend forecast for the periods from 1 to 13. Round your answers to the nearest whole number. Use unrounded intercept and slope values.
Period Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
Solved
Show answers
More tips
- L Leisure and Entertainment History of International Women s Day: When Did the Celebration of March 8th Begin?...
- S Style and Beauty Intimate Haircut: The Reasons, Popularity, and Risks...
- A Art and Culture When Will Eurovision 2011 Take Place?...
- S Style and Beauty How to Choose the Perfect Hair Straightener?...
- F Family and Home Why Having Pets at Home is Good for Your Health...
- H Health and Medicine How to perform artificial respiration?...
- H Health and Medicine 10 Tips for Avoiding Vitamin Deficiency...
- F Food and Cooking How to Properly Cook Buckwheat?...
- F Food and Cooking How Many Grams Are In a Tablespoon?...
- L Leisure and Entertainment Carving: History and Techniques for Creating Vegetable and Fruit Decorations...
Answers on questions: Business
- B Business Why might large corporations be more likely to support development of sustaining technology rather than emerging technology? a. the risk factors are too low. b. it s more expensive...
- B Business Types of ordering policies and the impact each has on safety inventory....
- B Business Why is it important to review your credit reports annually? What are the three most common credit report errors, and what should you do if you find error? What are the 2 most important...
- B Business No single system can adequately answer the demands made by diverse functions of cost systems. while companies can use one method to capture all their detailed transactions data,...
- B Business What does the investment component of gdp measure? a. spending on domestically produced goods by foreign buyers b. spending on goods to be used in future production c. spending...
- B Business Those who work directly on the product to convert raw materials into a finished product are known as...
- B Business All of the following are causing significant job loss for americans except: a. globalization b. outsourcing c. automation d. unionization...
- B Business Coupons and sales are frequently used marketing tactics for which form of competition?...
- B Business In this particular state, real estate agents tend to inspect properties in order to tell their clients of any defects that the property may have. katherine was leslie s real estate...
- B Business True or false? 1. the terms of a contract must be accepted it was communicated....
Ответ:
attached below is the required solution
Explanation:
1) Determine the trend line
The trendline ( Y ) = 319.58x + 989.39 ( attached below is a graph showing the trendline )
2) attached below is the table showing the calculation of Linear trend forecast
Ответ: