5. Management of a home appliance store wants tounderstand the growth pattern of the monthly sales of a new technology device over the past two years.The managers have recorded the relevant data inthe file P13_05.xlsx. Have the sales of this devicebeen growing linearly over the past 24 months? Byexamining the results of a linear trend line, explainwhy or why not.

5. Management of a home appliance store wants tounderstand the growth pattern of the monthly sales of a new technology device over the past two years.The managers have recorded the relevant data inthe file P13_05.xlsx. Have the sales of this devicebeen growing linearly over the past 24 months? Byexamining the results of a linear trend line, explainwhy or why not.

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter6: Exponential And Logarithmic Functions

Section6.8: Fitting Exponential Models To Data

Problem 5SE: What does the y -intercept on the graph of a logistic equation correspond to for a population...

See similar textbooks

Similar questions

What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?
The Beaver Creek Pottery Company sells bowls and mugs, hand-made by Native American artisans, at a craft store and through a Web site. Making these items requires a special type of clay and a large amount of individual person-hours, so for planning purposes, the company would like to forecast future demand, specifically through its Web site, which has increasingly become the primary source of sales. Following is the company’s Web site demand (in items sold) for the past 36 months: Develop a linear trend forecast model, an exponentially smoothed model (a = 0.20), and a 5-month moving average forecast model and indicate which one you think should be used to forecast Web site demand.
The sales records of a major auto manufacturer over the past years from 2005 to 2019 are shown below. Number of Cars Sold Year (In thousands of Units) 2005 195 2006 200 2007 250 2008 270 2009 320 2010 380 2011 440 2012 460 2013 500 2014 500 2015 550 2016 570 2017 600 2018 650 2019 700 Develop moving average with k=4 and compute its MSE Develop exponential model with α = 0.4 and compute its MSE Develop a linear trend model and compute its MSE Based on the MSE computed fore ach model , which model fits well to the data Based on the answer of question (4) forecast the number of cars sold for year 2020.
A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales duringthe last 15 days wereDay: 1 2 3 4 5 6 7 8 9Number sold: 36 38 42 44 48 49 50 49 52Day: 10 11 12 13 14 15Number sold: 48 52 55 54 56 57a. Which method would you suggest using to predict future sales—a linear trend equation or trendadjustedexponential smoothing? Why?b. If you learn that on some days the store ran out of the specific pain reliever, would that knowledgecause you any concern? Explain.c. Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with aninitial forecast of 50 for week 8, an initial trend estimate of 2, and .3, develop forecastsfor days 9 through 16. What is the MSE for the eight forecasts for which there are actual data?
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a trend line for the demand for fertilizer using any computer software? b) For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer?
4. Consider the following data. Period 1 rate of return -6.0. Period 2 rate of return -8.0. Period 3 rate of return -4.0. Period 4 rate of return 2.0. Period 5 rate of return 5.4. What is the mean growth rate over these five periods?
The president of State University wants to forecast student enrollments for this Year academic year based on the following historical data: 5 years ago 4 years ago 3 years ago 2 years ago Last year Enrollments 15.000 16.000 18.000 20.000 21.000 a- What is the forecast for this year using a 3-year weighted moving average where the weights are halved in a descending order from newest to oldest ? b. What is the forecast for this year using the trend line for these data? c. using the MAD find which forecasting technique may be appropriate for this quetion
Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 Augus 21,000September 23,000You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.b. Calculate the forecasted sales difference if you use 3-period weighted moving averagedesigned with the following weights: July 0.2, August 0.3 and September 0.5. Note: You need to show all the steps in your calculation. No excel files will be graded.
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.
Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020. Month Sales ($)April 17,000May 18,000June 19,500July 22,000August 21,000September 23,000 You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020 b. Calculate the forecasted sales difference if you use 3-period weighted moving averagedesigned with the following weights: July 0.2, August 0.3 and September 0.5. (2
Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000 You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.b. Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: July 0.2, August 0.3 and September 0.5. Note: You need to show all the steps in your calculation. No excel files will be graded.
An economist at Nedbank ran a study of the relationship between FTSE/JSE All Shares index return (JALSH) and consumer price index (CPI) from 2006 to 2017, the data collected is shown in the Table 1 below. FTSE/JSE All Shares index return (JALSH) and consumer price index (CPI) from 2006 to 2017. Year JALSH (Y) CPI (X) 2006 0.41 4.7 2007 0.19 7.1 2008 -0.23 11.5 2009 0.32 7.1 2010 0.19 4.3 2011 0.03 5.0 2012 0.27 5.6 2013 0.21 5.7 2014 0.11 6.1 2015 0.05 4.6 2016 0.00 6.4 2017 0.21 5.3 The estimated regression…