Year Actual (X) Actual Sales (Y) 1 450 2 495 3 518 4 563 5 584 a-
Fantastic news! We've Found the answer you've been seeking!
Question:
Year Actual (X) | Actual Sales (Y) |
1 | 450 |
2 | 495 |
3 | 518 |
4 | 563 |
5 | 584 |
a- Forecast the year 6 using simple linear regression (attach the excel file)
b- Test the model for significance at 5 % level
Transcribed Image Text:
V₁ 1 2 3 14 V₂ 1 2 3 4 5 6 7 9 10 12 161.4 199.5 215.7 224.6 234.0 236.8 230.2 19.30 19.33 19.35 18.51 238.9 240.5 241.9 243.9 19.00 19.16 19.25 19.37 19.38 19.40 1941 10.13 9.55 9.28 9.12 9.01 8.94 8.89 8.85 8.81 8.79 8.74 6.94 6.59 6.39 6.26 6.16 6.09 6.04 6.00 5.96 5.91 7.71 15 16 17 18 19 5 6 7 8 9 5.12 10 4.96 4.10 3.71 3.48 11 4.84 3.98 3.59 12 4.75 3.89 3.49 13 4.67 3.81 3.41 4.60 3.74 3.36 3.26 3.18 3.34 3.11 14 4.50 4.46 3.84 3.81 3.77 6.61 5.79 5.41 5.19 5.05 4.95 4.88 4.82 4.77 4.74 4.68 4.62 4.56 4.53 4.43 5.99 5.14 4.76 4.53 4.39 4.28 4.21 4.15 4.10 4.06 4.00 3.94 3.87 3.74 5.59 4.74 4.35 4.12 3.97 3.87 3.79 3.73 3.68 3.64 3.57 3.51 3.44 3.41 3.38 3.34 3.30 5.32 4.46 4.07 3.84 3.69 3.58 3.50 3.44 3.39 3.35 3.28 3.22 3.15 3.12 3.08 3.04 3.01 4.26 3.86 3.63 3.48 3.37 3.29 3.23 3.18 3.14 3.07 3.01 2.94 2.90 2.86 2.83 2.79 4.54 3.68 3.63 4.49 4.45 3.59 4.41 3.55 4.38 3.52 8 3.29 3.24 3.20 3.16 3.13 3.33 3.22 3.14 3.07 3.02 2.98 2.91 3.20 3.09 3.01 2.95 2.90 2.85 2.79 3.11 3.00 2.91 2.85 2.80 2.75 2.69 3,03 2.92 2.83 2.77 2.71 2.67 2.60 2.96 2.85 2.76 2.70 2.65 2.60 2.53 15 20 24 30 40 60 120 00 245.9 248.0 249.1 250.1 251.1 252.2 253.3 254.3 19.43 19.45 19.45 19.46 19.47 19.48 19.49 19.50. 8.70 8.66 8.64 8.62 8.59 8.57 8.55 8.53 5.86 5.80 5.77 5.75 5.72 5.69 5.66 5.63 3.06 2,90 2.79 2.71 2.64 2.59 2.54 2.48 3.01 2.85 2.74 2.66 2.59 2.54 2.49 2.42 2.96 2.81 2.70 2.61 2.55 2.49 2.45 2.38 2.93 2.77 2.66 2.58 2.51 2.46 2.41 2.34 2.90 2.74 2.63 2.54 2.48 2.42 2.38 2.31 4.40 4.36 3.70 3.67 3.27 3.23 2.97 2.93 2.75 2.71 2.85 2.77 2.74 2.70 2.66 2.62 2.58 2.54 2.72 2.65 2.61 2.57 2.53 2.49 2.45 2.40 2.62 2.54 2.51 2.47 2.43 2.38 2.34 2.30 2.53 2.46 2.42 2.38 2.34 2.30 2.25 2.21 2.46 2.39 2.35 2.31 2.27 2.22 2.18 2.13 2.16 2.11 2.07 2.11 2.06 2.01 2.40 2.33 2.29 2.25 2.20 2.35 2.28 2.24 2.19 2.15 2.31 2.23 2.19 2.15 2.10 2.27 2.19 2.15 2.11 2.06 2.02 1.97 1.92 2.23 2.16 2.11 2.07 2.03 1.98 1.93 1.88 2.06 2.01 1.96 V₁ 1 2 3 14 V₂ 1 2 3 4 5 6 7 9 10 12 161.4 199.5 215.7 224.6 234.0 236.8 230.2 19.30 19.33 19.35 18.51 238.9 240.5 241.9 243.9 19.00 19.16 19.25 19.37 19.38 19.40 1941 10.13 9.55 9.28 9.12 9.01 8.94 8.89 8.85 8.81 8.79 8.74 6.94 6.59 6.39 6.26 6.16 6.09 6.04 6.00 5.96 5.91 7.71 15 16 17 18 19 5 6 7 8 9 5.12 10 4.96 4.10 3.71 3.48 11 4.84 3.98 3.59 12 4.75 3.89 3.49 13 4.67 3.81 3.41 4.60 3.74 3.36 3.26 3.18 3.34 3.11 14 4.50 4.46 3.84 3.81 3.77 6.61 5.79 5.41 5.19 5.05 4.95 4.88 4.82 4.77 4.74 4.68 4.62 4.56 4.53 4.43 5.99 5.14 4.76 4.53 4.39 4.28 4.21 4.15 4.10 4.06 4.00 3.94 3.87 3.74 5.59 4.74 4.35 4.12 3.97 3.87 3.79 3.73 3.68 3.64 3.57 3.51 3.44 3.41 3.38 3.34 3.30 5.32 4.46 4.07 3.84 3.69 3.58 3.50 3.44 3.39 3.35 3.28 3.22 3.15 3.12 3.08 3.04 3.01 4.26 3.86 3.63 3.48 3.37 3.29 3.23 3.18 3.14 3.07 3.01 2.94 2.90 2.86 2.83 2.79 4.54 3.68 3.63 4.49 4.45 3.59 4.41 3.55 4.38 3.52 8 3.29 3.24 3.20 3.16 3.13 3.33 3.22 3.14 3.07 3.02 2.98 2.91 3.20 3.09 3.01 2.95 2.90 2.85 2.79 3.11 3.00 2.91 2.85 2.80 2.75 2.69 3,03 2.92 2.83 2.77 2.71 2.67 2.60 2.96 2.85 2.76 2.70 2.65 2.60 2.53 15 20 24 30 40 60 120 00 245.9 248.0 249.1 250.1 251.1 252.2 253.3 254.3 19.43 19.45 19.45 19.46 19.47 19.48 19.49 19.50. 8.70 8.66 8.64 8.62 8.59 8.57 8.55 8.53 5.86 5.80 5.77 5.75 5.72 5.69 5.66 5.63 3.06 2,90 2.79 2.71 2.64 2.59 2.54 2.48 3.01 2.85 2.74 2.66 2.59 2.54 2.49 2.42 2.96 2.81 2.70 2.61 2.55 2.49 2.45 2.38 2.93 2.77 2.66 2.58 2.51 2.46 2.41 2.34 2.90 2.74 2.63 2.54 2.48 2.42 2.38 2.31 4.40 4.36 3.70 3.67 3.27 3.23 2.97 2.93 2.75 2.71 2.85 2.77 2.74 2.70 2.66 2.62 2.58 2.54 2.72 2.65 2.61 2.57 2.53 2.49 2.45 2.40 2.62 2.54 2.51 2.47 2.43 2.38 2.34 2.30 2.53 2.46 2.42 2.38 2.34 2.30 2.25 2.21 2.46 2.39 2.35 2.31 2.27 2.22 2.18 2.13 2.16 2.11 2.07 2.11 2.06 2.01 2.40 2.33 2.29 2.25 2.20 2.35 2.28 2.24 2.19 2.15 2.31 2.23 2.19 2.15 2.10 2.27 2.19 2.15 2.11 2.06 2.02 1.97 1.92 2.23 2.16 2.11 2.07 2.03 1.98 1.93 1.88 2.06 2.01 1.96
Expert Answer:
Related Book For
Essentials of Statistics for Business and Economics
ISBN: 978-1305081598
7th edition
Authors: David Anderson, Thomas Williams, Dennis Sweeney, Jeffrey Cam
Posted Date:
Students also viewed these general management questions
-
A simple linear regression model relating y = total catch of lobsters (in kilograms) and x = average percentage of traps allocated per day to exploring areas of unknown catch (called search...
-
Test the significance of the regression model at Step 1 of the process. Justify the significance level you have selected. The J. J. McCracken Company has authorized its marketing research department...
-
The Excel output of a simple linear regression analysis of the data set for this case (see Exercise 13.5 on pages 527 and 528) is given in Figure 13.12. Recall that a labeled Excel regression output...
-
Find the area between the parabolas y = 2x 2 + 1 and y = x 2 + 5.
-
Company G received a bank statement at the end of the month. The statement contained the following: Ending balance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
What is the major advantage of spot-welding guns?
-
Compute manufacturing overhead variances (Learning Objective 5) Deelux manufactures paint. The company charges the following standard unit costs to production on the basis of static budget volume of...
-
The demand function for bicycles in Holland has been estimated to be Q = 2,000 + 15Y 5.5P Where Y is income in thousands of euros, Q is the quantity demanded in units, and P is the price per unit....
-
Total fixed costs are $ 5 0 , 0 0 0 when 5 , 0 0 0 units are produced. When 1 0 , 0 0 0 units are produced, fixed costs will be: $ 1 0 per unit $ 1 0 0 , 0 0 0 in total $ 5 0 , 0 0 0 in total None of...
-
If an amino acid is found at the exact same location in the alignment of two homologous proteins, that amino acid is said to be "absolutely conserved." An amino acid type can also be conserved at a...
-
The office's 4 Canon machines are expected to last 5 more years. They can each be sold immediately for $700; their resale value in 5 years will be zero. The Canon machines require 4 operators; they...
-
Define pressure angle of a gear.
-
How gyroscopic couple affect the motion of an aeroplane while taking a turn.
-
In a Proell governor, the mass of each ball is 5 kg and central load on sleeve is 50 kg. The length of each upper and lower arms is 250 mm. The minimum and maximum radii are 120 mm and 180 mm...
-
What is conjugate action in gears?
-
How a four-wheeled vehicle is affected by gyroscopic couple?
-
As a marketing consultant, and by using the ANSOFF MATRIX, suggest the possible expansion strategies Loro Piana can consider in the near future
-
One of the significant and relevant accounts for this cycle is equipment. For this account, what would typically be the most relevant assertions for the auditor to consider? Why is it important for...
-
Based on a survey of 425 masters programs in business administration, U.S. news & World Report ranked the Indiana University Kelley Business School as the 20th best business program in the country...
-
In 2008 the Better Business Bureau settled 75% of complaints they received (USA Today, March 2, 2009). Suppose you have been hired by the Better Business Bureau to investigate the complaints they...
-
PCWorld rated four component characteristics for 10 ultraportable laptop computers: features; performance; design; and price. Each characteristic was rated using a 0100 point scale. An overall...
-
How should the general manager divide his or her time between monitoring current-year results and planning for the future?
-
What is a business model, and what are its key elements?
-
The adjusted trial balance for Phoenix Consultant Corporation at the end of its fiscal year is shown below. Prepare the required closing entries. Phoenix Consultant Corporation Trial Balance December...
Study smarter with the SolutionInn App