MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
expand_more
expand_more
format_list_bulleted
Question
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year.
QUARTER | SALES |
---|---|
1 | 220 |
2 | 232 |
3 | 201 |
4 | 193 |
5 | 163 |
6 | 194 |
7 | 155 |
8 | 136 |
Use regression and seasonal indexes to forecast quarterly sales for the next year.
Note: Do not round intermediate calculations. Round your answers to the nearest whole number.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 32 images
Knowledge Booster
Similar questions
- Desmos | Graphing Calc Year Time (seconds) 1912 82.2 1924 72.4 1932 66.8 1952 66.8 1960 61.2 1968 60.0 1976 55.65 1984 55.92 1992 54.64 2000 53.8 2008 53.1 a. Decide which variable should be the independent variable and which should be the dependent variable. b. Draw a scatter plot of the data. C. Does it appear from inspection that there is a relationship between the variables? Why or why not? d. Find the equation in the form of: y= a + bx. e. Find the correlation coefficient. f. Find the estimated gold medal time for 1932. Find the estimated time for 1984. g. Why are the answers from part f different from the chart values? h. Does it appear that a line is the best way to fit the data? Why or why not? i. Use the least-squares line to estimate the gold medal time for the next Summer Olympics (Assuming they would be in 2020). Do you think that your answer is reasonable? Why or why not? Note that the fastest speed time in recorded history as of 2020 was 51.22 seconds for the 100 meter…arrow_forwardNonearrow_forwardthe table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.arrow_forward
- The following chart shows the actual sales for the last 12 months for a given company. Assume that sales are best fit by a linear trend and you can use single linear regression to set up a forecasting model. Using the sales data answer below questions (justify your answers): A.What would be the typical linear regression equation for the number of sales? B.Make the sales forecast for period 15 of next year. C. Make the sales forecast for period 17 of next year. D. What is the standard error for the data?arrow_forwardGraph the scatterplot and find the equation of the regression line GDP. CO2 emissions (in millions metric tons) 1.7. 552.6 1.2. 462.3 2.5. 475.4 2.8. 374.3 3.6. 748.5 2.2. 400.9 0.8. 253.0 1.5. 318.6 2.4. 496.8 5.9. 1180.6arrow_forwardEloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yesarrow_forward
- Table 3 gives the market value of a luxury sedan (in dollars) xyears after its purchase. Find an exponential regression model of the form y= ab* for this data set. Estimate the purchase price of the sedan. Estimate the value of the sedan 10 years after its purchase. Round answers to the nearest dollar. TABLE 3 Value ($) 1 23,125 19,050 3 15,625 11,875 5 9,450 6 7,125 2.arrow_forwardneed help with followingarrow_forwardLife expectancy in the United States has been rising since the nineteenth century. The table shows the U.S. life expectancy in selected years. Year 1950 1960 1970 1980 1990 2000 Life expectancy at birth 68.2 69.7 70.8 73.7 75.4 77 a. Let t represent the number of years after 1950, and plot the data. Draw a line a best fit for the data points. 80+ 76- 5 10 15 20 25 30 35 40 45 50 Draw: 72+ 64- 60+ 56 52 48- 44 Clear Allarrow_forward
- Please help me. Thankyou.arrow_forward. Fill in the "Years since 1970" column for the data to the right. Make a scatter plot in Excel of the data using Years since 1970 and Total Waste in Millions of Tons (Title your graph and label your axes appropriately). How would you best describe the trend? Add an exponential regression model to the data. Write the equation below. Is it a good fit? Explain how you know. Based on the exponential model, what is the growth rate per year? Explain the meaning of the growth rate in the context of the data. Using the exponential model, make a prediction of how much plastic will be in landfills (and the ocean gyres) by Year Years since 1970 Total Waste in Millions of Tons 1970 0 249 1980 10 798 1985 15 1200 1990 20 1740 1995 25 2440 2000 30 3390 2005 35 4600 2010 40 6060 2015 45 7820 Do you think recycling alone will solve this problem (See Q11 and Q12)? What are some of the challenges in recycling plastic that might hinder the world from recycling all plastic…arrow_forwardWhat is the explanatory variable, what is the response variable. What is the regression equation for this data. Plot the regression line in your calculator and draw it on your graph. Interpret in context the slope. Interpret in context the y-intercept. What is the residual at 45 years of age. Plot the residual plot on the axis to the rightarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
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