The following data are the last three years of quarterly sales ($ thousands) for AmeriWeld. They are looking to forecast their sales forthe upcoming year, 2021.Quarter2018 Q1Sales $ thousands (y)151Q2214Q33.13Q4372019 Q1Q2Q3Q42020 Q15463476773778910Q2Q3Q462119412101Click here for the Excel Data File. Data file should open in a new browswer window. Select "File" then "Save As" to download the file toyour computer and be able to use it in Excel.a. Determine the regression equation.Regression equation: ŷ =(Round to 2 decimal places.)b. Determine the specific index for each quarter.2 decimal places.)(Indexes should be in decimal form (e.g. 1.36 not 136). Rounded toQuarterQuarterly IndexQ1Q2Q3Q4c. What are the estimated sales (forecast) for the next four quarters?(Values in $thousands. Round to 2 decimal places.)QuarterForecasted Sales2021-12021-22021-32021-3

Answered: The following data are the last three…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

For the following data of sales data. Use exponential smoothing to forecast sales in the next week. Use α = 0.1, and 0.4 and compare errors. Graph the original and forecasted data.
An economist want to determine the relation between one’s FICO score, x, and the interest rate of a 36-month auto loan, y. The given data represent the interest rate (in percent) a bank would offer on a 36-month auto load for various FICO scores. Credit Score;x Interest Rate (percent);y 545 18.982 595 17.967 640 12.218 675 8.612 705 6.68 750 5.15 Find the least-squares regression line treating the FICO score as the explanatory variable and the interest rate as the response variable. Predict the interest rate a person would pay if their FICO score were the median score of 723.
Please answer 4.12 only and show complete solution. Thank you!
Assume this is a partial list of financial highlights from a Best Buy annual report: 2018 2017 (dollars in millions) Net sales $ 41,580 $ 36,275 Earnings before taxes 2,311 1,323 Net earnings 1,398 931 Complete a horizontal and vertical analysis from the above information. (Enter your answers in millions. Round the "percent" answers to the nearest hundredth percent.) Horizontal analysis Vertical analysis 2018 2017 Increase Percent 2018 2017 Net sales $41,580 $36,275 $5,305 100.00 % 100.00 % Earnings before taxes 2,311 1,323 988 % % Net earnings 1,398 931 467 % %
The electric power consumed each month by a chemical plant is thought to be related to the average ambient temperature (x₁), the number of days in the month (x₂), the average product purity (x3), and the tons of product produced (x4). The past year's historical data are available and are presented in the following table: Y 240 236 270 274 301 316 270 296 267 276 288 261 25 31 45 60 65 72 80 84 75 60 50 38 X2 24 21 24 25 25 26 25 25 24 25 25 23 Fit a multiple linear regression to predict power (y) using x1, X2 X3, and X4. Calculate R2 for this model. Round your answer to 3 decimal places. 91 90 88 87 91 94 87 86 88 91 90 89 X4 100 95 110 88 94 99 97 96 110 105 100 98
A company has the following monthly sales for the past year. Plot the data points on a line graph and describe the results. Month Sales 1 145 2 146 3 145 4 150 5 148 6 150 7 156 8 160 9 158 10 153 11 152 12 154
The value of a certain car when it was brand new with 0 mileage was $17,000 but the value dropped to $4,000 when the car acounulated 80,000 miles shown in the scatter plot below. Car's Mleage and Value S17.000 $2,000 Mileage Based on the data in the scatter plot, at what mileage was the car worth about $12,000? O 20,000 miles O 30,000 miles O 60,000 miles O 80,000 miles
Kahuna's Credit Union conducted a survey as to how long customers claimed to wait in the checkout line until their turn. Let X = time in line. The table below displays the ordered real data (in minutes): 0.50 4.25 5 6 7.25 1.75 4.25 5.25 6 17.25 2 4.25 5.25 6.25 7.25 2.25 4.25 5.5 6.25 7.75 2.25 45 55 65 8 2.5 4.75 55 65 825 2.75 4.75 5.75 6.5 19.5 3.25 4.75 5.75 6.75 95 3.755 16 6.75 9.75 3.75 5 6 6.75 10.75 Calculate the sample mean and the sample standard deviation to the nearest hundreths.
The electric power consumed each month by a chemical plant is thought to be related to the average ambient temperature x1, the number of days in the month x2, the average product purity x3, and the tons of product produced x4. The past year's historical data are available and are presented in the following table. Y 240 236 290 274 301 316 300 296 267 276 288 261 x1 25 31 45 y=a+a 60 65 72 80 84 75 60 50 38 X₂ 24 21 24 25 25 26 25 25 24 25 25 23 X3 91 90 88 87 91 94 87 86 88 91 90 89 X4 100 95 110 88 94 99 97 96 110 105 100 98 =a + ax + ax + a 11 2 2 value of a? Use 4 decimal places. 3x3+ax represents the regression model. What is the 4 4
I'm running out of questions. Can I pay for 30 more extra?
Yes, because 0.089 = (0.3)(0.158) No, because 0.089 ≠ (0.3)(0.158) Yes, because 0.047 = (0.3)(0.158) No, because 0.047 ≠ (0.3)(0.158)
Sales for the past 12 months at Computer Success are given here. Month Sales ($) Month Sales ($) January February March April May June 3000 3400 3700 4100 4700 5700 July August September October November December 6300 7200 6400 4600 4200 3900 a. Use a three-month moving average to forecast the sales for the months May through December.b. Use a four-month moving average to forecast the sales for the months May through December.c. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend?d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend?e. Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?

SEE MORE QUESTIONS

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS