The quarterly sales of the TRK-50 mountain bike for the previous four years by a bicycle shop in Switzerland is presented in the following table. Year 1 2 3 Quarter 1 2 3 4 1 2 3 4 1 2 3 st 4 1 2 3 4 t 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Yt 10 31 43 16 11 33 45 17 13 34 48 19 15 37 51 21 (a) By using a software of your choice, plot the time series (b) What kind of trend appears to exist? (c) What type of seasonal variation appears to exist? (d) Is a transformation needed to obtain a series that displays constant variation? (e) Fit a proper model with trend and seasonal variations terms. (f) Do all the independent variables seem to be important? Justify your answer statistically. (g) Write out the definitions of the dummy variables Q2, Q3, and Q4 (h) Predict the bike sales in year 5. Find point estimation and 95% confidence and prediction interval. (i) Write the prediction equation for the model, and use it to calculate y17 and y18

The quarterly sales of the TRK-50 mountain bike for the previous four years by a bicycle shop in Switzerland is presented in the following table. Year 1 2 3 Quarter 1 2 3 4 1 2 3 4 1 2 3 st 4 1 2 3 4 t 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Yt 10 31 43 16 11 33 45 17 13 34 48 19 15 37 51 21 (a) By using a software of your choice, plot the time series (b) What kind of trend appears to exist? (c) What type of seasonal variation appears to exist? (d) Is a transformation needed to obtain a series that displays constant variation? (e) Fit a proper model with trend and seasonal variations terms. (f) Do all the independent variables seem to be important? Justify your answer statistically. (g) Write out the definitions of the dummy variables Q2, Q3, and Q4 (h) Predict the bike sales in year 5. Find point estimation and 95% confidence and prediction interval. (i) Write the prediction equation for the model, and use it to calculate y17 and y18

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter4: Linear Functions

Section4.3: Fitting Linear Models To Data

Problem 24SE: Table 6 shows the year and the number ofpeople unemployed in a particular city for several years....

See similar textbooks

Similar questions

Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?
Enter the data from Table 2 into a graphing calculator and graph the ranking scatter plot. Determine whetherthe data from the table would likely represent a function that is linear, exponential, or logarithmic.
What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?
A bank wanted to find out whether the number of loan applications received are influenced by the current loan interest rate. The manager selected 11 monthly periods for which different interest rates applied and recorded the number of loan applications received. (b) Show the data graphically in a scatter plot. What relationship is observed? SHOW SOLUTION PLEASE!
Examine the data for each race/ethnicity group. Do the data represent a stationary or nonstationary process? Do any of the race/ethnicity groups exhibit a decreasing trend? Do any of the race/ethnicity groups show a strictly increasing trend over the entire time period from 2000 to 2016?
lakhs) of a certain commodity for the year On the basis of quarterly sales (in 2008-12, the following calculations were made : Trend: Y = 20 + 0.5 t with origin at 1st quarter of 2008. where 1 = time unit = one quarter and y = quarterly sales ( Seasonal variations: Quarter I II III IV Seasonal Index 80 90 120 110 Estimate the quarterly sale for the year 1979 using multiplicative model.
The population of a town was recorded every twenty years from 1900 to 2000. The results are shown in the line graph. Assuming that the trend in the population growth continues, which of the following is most likely to be the population of the town in the year 2020?
The following table is a selection of average prices for a gallon of gas in the United States. Year Gas Price Index Value 2001 [A] 2003 [B] 2004 2018 [A] = Build an index from these values, using 2003 as the base year. Round each index value to the nearest tenth. [B] = = [C] = $1.42 $1.56 $1.85 $2.72 [D] = [C] [D]
A coffee shop owner wants to estimate demand for the next four quarters for hot chocolate. Sales data consist of trend and seasonality. Quarter relatives are 1.06 for the first quarter, 1.03 for the second quarter, 0.61 for the third quarter, and 1.30 for the fourth quarter. Using the appropriate values of quarter relatives and the equation Ft = 187 +9.2t for the trend component, estimate demand for periods 9-12. (Round all calculations to two decimal points. Demand Period 9 Demand Period 10 Demand Period 11. Demand Period 12
The following scatter plot represents population growth at a new school starting in 2021. (Graph is attached).Using the trendline, predict the population for the school in 2030.
Cryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021. It includes the following variables: Date Day – Day of the year, used to assess trend over time Volume (US $) – Daily trading volume Opening Price (US $) – Opening price for daily trading Price Change (US $) – Daily change in price from opening to close 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)
For the Texas Shipping Company, the monthly percentages of all shipments received on time over the past 12 months are 82, 86, 87, 89, 84, 85, 84, 86, 75, 95, 90, and 92. a. Construct a time series plot (you can include it in the work file question at the end, not here). Identify what type of pattern, if any, exists in the data? Compare the three-month moving average forecast with an exponential smoothing forecast for alpha= 0.25 and answer the following: b. MSE for 3-month moving average method c. MSE for exponential-smoothing method : d. Which method should be preferred? Answer "3-month MA" or "Exponential Smoothing": e. What is the forecast for next month using the preferred method?