Consider the demand for trading cards as listed below. Month Demand January 48,000 February 40,000 March 56,000 April 64,000 May 76,000 June 74,000 July 78,000 August 93,000 September 98,000 Use Excel to prepare a forecast for October, November, and December using linear regression. Please show the slope and the intercept of the linear regression model. a) The slope is b) The intercept is (round your response to two decimal places). (round your response to two decimal places). c) The forecast demand for October is d) The forecast demand for November is e) The forecast demand for December is (round your response to the nearest integer). (round your response to the nearest integer). (round your response to the nearest integer).

Consider the demand for trading cards as listed below. Month Demand January 48,000 February 40,000 March 56,000 April 64,000 May 76,000 June 74,000 July 78,000 August 93,000 September 98,000 Use Excel to prepare a forecast for October, November, and December using linear regression. Please show the slope and the intercept of the linear regression model. a) The slope is b) The intercept is (round your response to two decimal places). (round your response to two decimal places). c) The forecast demand for October is d) The forecast demand for November is e) The forecast demand for December is (round your response to the nearest integer). (round your response to the nearest integer). (round your response to the nearest integer).

Algebra and Trigonometry (MindTap Course List)

4th Edition

ISBN:9781305071742

Author:James Stewart, Lothar Redlin, Saleem Watson

Publisher:James Stewart, Lothar Redlin, Saleem Watson

Chapter1: Equations And Graphs

Section1.FOM: Focus On Modeling: Fitting Lines To Data

Problem 12P: Demand for Candy Bars In this problem you will determine a linear demand equation that describes the...

See similar textbooks

Similar questions

Life Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300
Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4
What is regression analysis? Describe the process of performing regression analysis on a graphing utility.
Demand for Candy Bars In this problem you will determine a linear demand equation that describes the demand for candy bars in your class. Survey your classmates to determine what price they would be willing to pay for a candy bar. Your survey form might look like the sample to the left. a Make a table of the number of respondents who answered yes at each price level. b Make a scatter plot of your data. c Find and graph the regression line y=mp+b, which gives the number of respondents y who would buy a candy bar if the price were p cents. This is the demand equation. Why is the slope m negative? d What is the p-intercept of the demand equation? What does this intercept tell you about pricing candy bars? Would you buy a candy bar from the vending machine in the hallway if the price is as indicated. Price Yes or No 50 75 1.00 1.25 1.50 1.75 2.00
Does Table 1 represent a linear function? If so, finda linear equation that models the data.