Year Quarter Revenue 2005 Qtr1 5,206   Qtr2 6,310   Qtr3 6,037   Qtr4 5,551 2006 Qtr1 5,226   Qtr2 6,476   Qtr3 6,454   Qtr4 5,932 2007 Qtr1 6,103   Qtr2 7,733   Qtr3 7,690   Qtr4 7,331 2008 Qtr1 7,379   Qtr2 9,046   Qtr3 8,393   Qtr4 7,126 2009 Qtr1 7,169   Qtr2 8,267   Qtr3 8,044   Qtr4 7,510 2010 Qtr1 7,525   Qtr2 8,674   Qtr3 8,426   Qtr4 10,494 State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places.)   yt =  +  t +  Q1 +  Q2 +  Q3   Use the regression equation to make a prediction for each quarter in 2011. (Enter your answers in millions rounded to 3 decimal places.)   Quarter Predicted Q1   Q2   Q3   Q4

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Year Quarter Revenue
2005 Qtr1 5,206
  Qtr2 6,310
  Qtr3 6,037
  Qtr4 5,551
2006 Qtr1 5,226
  Qtr2 6,476
  Qtr3 6,454
  Qtr4 5,932
2007 Qtr1 6,103
  Qtr2 7,733
  Qtr3 7,690
  Qtr4 7,331
2008 Qtr1 7,379
  Qtr2 9,046
  Qtr3 8,393
  Qtr4 7,126
2009 Qtr1 7,169
  Qtr2 8,267
  Qtr3 8,044
  Qtr4 7,510
2010 Qtr1 7,525
  Qtr2 8,674
  Qtr3 8,426
  Qtr4 10,494

State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places.)
 
yt =  +  t +  Q1 +  Q2 +  Q3
 
Use the regression equation to make a prediction for each quarter in 2011. (Enter your answers in millions rounded to 3 decimal places.)
 

Quarter Predicted
Q1  
Q2  
Q3  
Q4  
 

 

Expert Solution
Step 1

Excel is used in order to obtain the regression model using seasonal binaries. Steps are as;

1. Enter the data as shown below.

Statistics homework question answer, step 1, image 1

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Factorization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman