Consider the demand for trading cards as listed below.Month DemandJanuary 48,000February 40,000March 56,000April64,000May76,000June74,000July78,000August93,000September98,000Use 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 isb) The intercept is(round your response to two decimal places).(round your response to two decimal places).c) The forecast demand for October isd) The forecast demand for November ise) 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).

It is required to develop a linear regression, and prepare the forecasts for the months of October,…

Answered: Consider the demand for trading cards…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Use the linear regression models above to answer this question. There are two break-even points. Find the larger production level where the company breaks even. Round to the nearest treadmill. treadmills
What is the dollar amount of change in sales for each new year according to the regression (slope) model? Do not use commas or $ in your answer.
The following chart shows the actual sales for the last 12 months for a given company. Assume that sales are best fit by a linear trend and you can use single linear regression to set up a forecasting model. Using the sales data answer below questions (justify your answers): A.What would be the typical linear regression equation for the number of sales? B.Make the sales forecast for period 15 of next year. C. Make the sales forecast for period 17 of next year. D. What is the standard error for the data?
$339,380 $41,768 A national homebuilder builds single-family homes and condominium-style townhouses. The accompanying dataset provides information on the selling price, lot cost, and type of home for closings during one month. Complete parts a through c. E Click the icon to view the house sales data a. Develop a multiple regression model for sales price as a function of lot cost and type of home without any interaction term. Create a dummy variable named "Townhouse", where it is equal to 1 when Type = "Townhouse" and 0 otherwise. Determine the coefficients of the regression equation. Sales Price = 108726 + (3.68 ) • Lot Cost + ( - 75063 )• Townhouse (Round the constant and coefficient of Townhouse to the nearest integer as needed. Round all other values to two decimal places as needed.) b. Determine if an interaction exists between lot cost and type of home and find the best model. Use a = 0.1 as the level of significance. First determine whether an interaction exists. Select the…
The value of a sports franchise is directly related to the amount of revenue that a franchise can generate. The following data represents the value in 2014 (in $millions) and the annual revenue (in $millions) for the 30 Major League Baseball franchises. Suppose you want to develop a simple linear regression model to predict franchise value based on annual revenue generated. Team Revenue Value Baltimore 245 1000 Boston 370 2100 Chicago White Sox 227 975 Cleveland 207 825 Detroit 254 1125 Houston 175 800 Kansas City 231 700 Los Angeles Angels 304 1300 Minnesota 223 895 New York Yankees 508 3200 Oakland 202 725 Seattle 250 1100 Tampa Bay 188 625 Texas 266 1220 Toronto 226 870 Arizona 211 840 Atlanta 267 1150 Chicago Cubs 302 1800 Cincinnati 227 885 Colorado…
Perform a linear regression analysis on the following data and determine the "a" coefficient (i.e., slope): Y 4.99 22.19 1.96 9.89 2.98 11 9 40.46 4.04 18.93 6.06 25 0.88 0.19 8.02 34.02 6.97 28.03
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 99% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $925. The equation of the regression line is
Tuition($) Applicant Pool Applicant 950 76210 11040 1225 78000 10940 1325 67420 8670 1350 70380 9040 1500 62580 7410 1675 59260 7080 1800 57930 6350 1975 60130 6110 a. Using POMQM, develop the multiple regression equation for these data. b. What is the coefficient of determination for this regression equation? c. Determine the forecast for freshman applicants for a tuition rate of $1700 per semester, with a pool of applicants of 63000. CAN YOU SHOW ME ALL THE ANSWER WİTH EXCELL TABLE
A. Develop an estimated regression equation that can be used to predict the price of the stock based on the number of shares of company's stocks sold and the volume of exchange. B. Interpret the coefficients of the estimated regression equation that you found in Part a. C. If in a given day, the number of shares of the company that were sold was 94,500 and the volume of exchange on the New York Stock Exchange was 16 million, what would you expect the price of the stock to be?
Which of the following statements best describes linear regression? A measure of the degree of dependence between two variables. A statistical technique using pairs of data and identifying a line which ‘best fits’ all of the pairs of observations. A measure of the proportion of changes in the dependent variable which can be explained by a change in the independent variable. Shows individual costs against their associated activity levels but makes no attempt to identify a linear relationship between them.
What is the explanatory variable, what is the response variable. What is the regression equation for this data. Plot the regression line in your calculator and draw it on your graph. Interpret in context the slope. Interpret in context the y-intercept. What is the residual at 45 years of age. Plot the residual plot on the axis to the right

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS