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?
A popular television show recently released a video preview for the upcoming season on its website. As fans of the show discover the video, the number of views of the preview video has grown each day during the last 2 weeks. The number of days since the release of the video and the natural log of the number of video views is shown in the scatterplot. Based on the scatterplot and residual plot, what type of model would be appropriate for summarizing the relationship between days and number of views? An exponential model is appropriate because the residual plot does not show a clear pattern. A linear model is appropriate because the scatterplot shows a strong, positive linear relationship. A power model is appropriate because the scatterplot of days and natural log of views is strong and linear. An exponential model is appropriate because the relationship between days and the natural log of views is linear, and the residual plot does not show a clear pattern.
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…
The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 98% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $878.The equation of the regression line is y=1.342x+55.816. Wages [state]- 712, 746, 786, 803, 841, 879, 918, 926, 954, 979 Wages [federal]- 1,024, 1,048, 1,098, 1,135, 1,195, 1,240, 1,270, 1,299, 1,340, 1,376 Construct and interpret a 98% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $878. Select the correct choice below and fill in the answer boxes to complete your choice. (Round to the nearest cent as needed.) PICK THE CORRECT ANSWER [A] We can be 98% confident that when the average weekly wages of state government employees is $878, the average weekly wages of…
Apple CAPM Data file posted on has data about the monthly return on Apple Inc. from 1981 to 2005 (300 months) as well as the monthly return on the whole stock market (measured by a value-weight stock market index) and the monthly return on 30-day Treasury Bills. Use this file to answer the following questions: Show all your work, Use Excel. A) Run a regression of the excess return on Apple Inc. on the excess return on the whole marketand write down your estimated equation. B) What is Beta for Apple Inc.? Is it significant C) What is Alpha for Apple Inc.? Is it significant
The U.S. Postal Service is attempting to reduce the number of complaints made by the public against its workers. To facilitate this task, a staff analyst for the service regresses the number of complaints lodged against an employee last year on the hourly wage of the employee for the year. The analyst ran a simple linear regression in SPSS. The results are shown below. What proportion of variation in the number of complaints can be explained by hourly wages? From the results shown above, write the regression equation If wages were increased by $1.00, what is the expected effect on the number of complaints received per employee?