Bin Inc. collected data representing sales in (millions of dollars) of a new facet for the first three weeks (Monday to Friday) of business activity. The company wants to use the partial Excel Summary Output and the Time Series data below to develop a regression equation and use seasonal indexes to estimate their sales. Note: time period (t=1, 2, 3……..)← < Coefficients Standard Error t Stat Intercept 86.9 3.266131055 26.6136931 0.393 0.359226522 1.093619536 < Day Sales Week 1 M< 85 T 89 We 83 T 95 7 17 17 77 F 97 心 2 Week 2 Me 84 T 88 We 83 T< 97 77 7 77 F< 99 1 17 Week 3 | Me 86 ཀླུ|" T< 88 We 84< 7 17 77 T F 95 < 98 7 17 P-value Lower 95% Upper 95% 1.00685E-12 79.86776236 93.97985668 0.293972677 -0.383204577 1.168918862 Y/ŷ 0.974 1.015 < 0.942 1.074 1.073 1.090 0.943 0.961 0.913 1.028 2 1.056 2

Bin Inc. collected data representing sales in (millions of dollars) of a new facet for the first three weeks (Monday to Friday) of business activity. The company wants to use the partial Excel Summary Output and the Time Series data below to develop a regression equation and use seasonal indexes to estimate their sales. Note: time period (t=1, 2, 3……..)← < Coefficients Standard Error t Stat Intercept 86.9 3.266131055 26.6136931 0.393 0.359226522 1.093619536 < Day Sales Week 1 M< 85 T 89 We 83 T 95 7 17 17 77 F 97 心 2 Week 2 Me 84 T 88 We 83 T< 97 77 7 77 F< 99 1 17 Week 3 | Me 86 ཀླུ|" T< 88 We 84< 7 17 77 T F 95 < 98 7 17 P-value Lower 95% Upper 95% 1.00685E-12 79.86776236 93.97985668 0.293972677 -0.383204577 1.168918862 Y/ŷ 0.974 1.015 < 0.942 1.074 1.073 1.090 0.943 0.961 0.913 1.028 2 1.056 2

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 1TI: Table 2 shows a recent graduate’s credit card balance each month after graduation. a. Use...

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?
Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4
Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to 2012. a. Let x represent time in years starting with x=0 for the year 1997. Let y represent the number of seals in thousands. Use logistic regression to fit a model to these data. b. Use the model to predict the seal population for the year 2020. c. To the nearest whole number, what is the limiting value of this model?
Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?
Does Table 1 represent a linear function? If so, finda linear equation that models the data.
Can the average rate of change of a function be constant?
Question is in the photo attached.
While attempting to measure its risk exposure for the upcoming year, an insurance company notices a trend between the age of a customer and the number of claims per year. It appears that the number of claims keep going up as customers age. After performing a regression, they find that the relationship is (claims per year) = 0.17* (age) + 2.04. If a customer is 47 years old and they make an average of 14.72 claims per year, what is the residual?
Find the degrees of freedom in a regression model with an intercept term that has 88 observations and 7 explanatory variables.
What is meant by the slope of the regression line?
While attempting to measure its risk exposure for the upcoming year, an insurance company notices a trend between the age of a customer and the number of claims per year. It appears that the number of claims keep going up as customers age. After performing a regression, they find that the relationship is (claims per year) = 0.385*(age) + 5.218. If a customer is 44.315 years old and they make an average of 11.239 claims per year, the residual is -11.04. Interpret this residual in terms of the problem. Question 10 options: 1) The number of claims per year is 11.04 claims less than what we would expect. 2) The age is 11.04 years larger than what we would expect. 3) The age is 11.04 years less than what we would expect. 4) The number of claims per year is 11.239 claims less than what we would expect. 5) The number of claims per year is 11.04 claims…
According to human capital theory, a person’s earning is linked to her level of education – there is a relationship between workers income and years of education. Using data from the Labour Force Survey, a researcher found the following regression results for earnings on intercept, years of education, experience, and experience squared: Earnings = 5.24 + 0.035 educ + 0.165 exper – 0.003 exper2 (2.45) (0.012) (0.031) (0.001) Construct a 95% confidence interval for the effect of years of education on earnings ? 2. Consider an individual with 8 years of experience. What would you expect to be the return to two (2) additional years of experience (the effect on earnings)? 3. According to economic theory,…