Question

In: Statistics and Probability

The number of users of a certain website (in millions) from 2004 through 2011 follows. Year...

The number of users of a certain website (in millions) from 2004 through 2011 follows.

Year Period Users (Millions)
2004 1 1
2005 2 6
2006 3 12
2007 4 57
2008 5 144
2009 6 361
2010 7 608
2011 8 846

Using Minitab or Excel, develop a quadratic trend equation that can be used to forecast users (in millions). (Round your numerical values to one decimal place.)

Tt =

Consider the following time series.

Quarter Year 1 Year 2 Year 3
1 72 69 63
2 49 41 51
3 58 60 53
4 77 80 71

b) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects in the data:

x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise.

=

(c)Compute the quarterly forecasts for next year.

quarter 1 forecast

quarter 2 forecast

quarter 3 forecast

quarter 4 forecast

Solutions

Expert Solution


Related Solutions

Apple’s Worldwide Revenues from 2004 to 2019 is as follows: Year Worldwide Revenue in Billions 2004...
Apple’s Worldwide Revenues from 2004 to 2019 is as follows: Year Worldwide Revenue in Billions 2004 8.2 2005 13.9 2006 19.3 2007 24.6 2008 37.5 2009 42.9 2010 65.2 2011 108.2 2012 156.5 2013 170.9 2014 182.8 2015 233.72 2016 215.64 2017 229.23 2018 265.6 2019 260.17 Enter the data above into the tab labeled Apple. Graph the data in Excel and use your graph to determine what kind of time series pattern exist. Put your answer in your spreadsheet....
A certain website wants you to build a 6-character password from the letters a through i,...
A certain website wants you to build a 6-character password from the letters a through i, the numbers 0 − 9, or the symbols @, #, or &. Clearly, the order of the characters in the password matters (a) How many passwords are there in total? (b) How many passwords are there that consist of distinct characters? (c) How many passwords have the first two characters be letters, the middle two character be one of the symbols and the last...
The flowing numbers come from an equity statement for fiscal year 2011 (in millions): Shareholders’ equity...
The flowing numbers come from an equity statement for fiscal year 2011 (in millions): Shareholders’ equity May 31, 2010 $2,700 Issue of shares for exercise of stock options 405 Repurchase of shares (132) Net income 467 Unrealized loss on debt securities (23) Tax benefit from the exercise of stock options 70 Common dividends paid (250) Preferred dividends paid (10) Shareholders’ equity May 31, 2011 3,227 The firm’s tax rate is 35 percent. Shareholders’ equity at May 31, 2010 includes $120...
3. Apple’s Worldwide Revenues from 2004 to 2019 is as follows: Year Worldwide Revenue in Billions...
3. Apple’s Worldwide Revenues from 2004 to 2019 is as follows: Year Worldwide Revenue in Billions 2004 8.2 2005 13.9 2006 19.3 2007 24.6 2008 37.5 2009 42.9 2010 65.2 2011 108.2 2012 156.5 2013 170.9 2014 182.8 2015 233.72 2016 215.64 2017 229.23 2018 265.6 2019 260.17 a. Enter the data above into the tab labeled Apple. Graph the data in Excel and use your graph to determine what kind of time series pattern exist. Put your answer in...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 ​Goods: exports ​77,939 ​102,175 ​123,876 ​153,530 ​199,065 ​167,958 ​230,967 ​307,847 ​298,321 ​319,110 ​329,633 ​Goods: imports ​-95,539 ​-134,692 ​-166,572 ​-208,611 ​-291,740 ​-247,908 ​-324,320 ​-428,021 ​-450,249 ​-433,760 ​-415,529      Balance on goods ​-17,600 ​-32,517 ​-42,696 ​-55,081 ​-92,675 ​-79,950 ​-93,353 ​-120,174 ​-151,928 ​-114,650 ​-85,895 ​Services: credit ​38,281 ​52,527 ​69,440 ​86,552 ​106,054 ​92,889 ​117,068 ​138,528 ​145,525 ​148,649 ​156,252 ​Services: debit ​-35,641 ​-47,287 ​-58,514 ​-70,175 ​-87,739 ​-80,349 ​-114,739 ​-125,041...
The year-end net income (in millions) for a company for the years 2004-2015 are shown in...
The year-end net income (in millions) for a company for the years 2004-2015 are shown in the provided data set (incomedata.xlsx). Graph the best chart which effectively displays the income data over time. Income Data: Year Net income 2004 25.2 2005 32.8 2006 31.5 2007 31.3 2008 34.8 2009 37.1 2010 62.1 2011 101.6 2012 75.5 2013 83.3 2014 117.4 2015 152.6
The number of hits to a website follows a Poisson process. Hits occur at the rate...
The number of hits to a website follows a Poisson process. Hits occur at the rate of 0.8 per minute between​ 7:00 P.M. and 9​:00 P.M. Given below are three scenarios for the number of hits to the website. Compute the probability of each scenario between 8:39 P.M. and 8​:47 P.M. Interpret each result. ​(a) exactly seven P(7)= (Round to four decimal places as​ needed.) ​(b) fewer than seven ​(c) at least seven ​ ​(Round to four decimal places as​...
At a certain black spot, the number of traffic accidents per year follows a Po 10,000)-distribution....
At a certain black spot, the number of traffic accidents per year follows a Po 10,000)-distribution. The number of deaths per accident follows a Po(0.1)-distribution, and the number of casualties per accidents follows a Po(2)-distribution. The correlation coefficient between the number of casualties and the number of deaths per accidents is 0.5. Compute the expectation and variance of the total number of deaths and casualties during a year.
The algorithm is basically as follows. The notation is slightly different from that in the website...
The algorithm is basically as follows. The notation is slightly different from that in the website you were given, but there is no difference in the method. Given the initial value problem dy/dx=f(x,y),y(a)= y_0 Euler’s Method with step size h consists in applying the iterative formula y_(n+1)= y_n+h∙f(x_n,y_n ),n≥0 To compute successive approximations y_1,y_2,y_3,⋯ to the (true) values 〖y(x〗_1),〖y(x〗_2),〖y(x〗_3),⋯ of the exact solution y=y(x) at the points x_1,x_2,x_3,⋯, respectively. In plain English: You want to approximate the value of dy/dx...
The algorithm is basically as follows. The notation is slightly different from that in the website...
The algorithm is basically as follows. The notation is slightly different from that in the website you were given, but there is no difference in the method. Given the initial value problem dy/dx=f(x,y),y(a)= y_0 Euler’s Method with step size h consists in applying the iterative formula y_(n+1)= y_n+h∙f(x_n,y_n ),n≥0 To compute successive approximations y_1,y_2,y_3,⋯ to the (true) values 〖y(x〗_1),〖y(x〗_2),〖y(x〗_3),⋯ of the exact solution y=y(x) at the points x_1,x_2,x_3,⋯, respectively. In plain English: You want to approximate the value of dy/dx...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT