Question: The data below, stored in Computer Usage represent the hours per day spent by American desktop and laptop users from 2008 to 2017. a. Plot

The data below, stored in Computer Usage represent the hours per day spent by American desktop and laptop users from 2008 to 2017.

Year Hours per Day Year Hours per Day 2008 2.2 2013 2.3

a. Plot the time series.
b. Fit a three-year moving average to the data and plot the results.
c. Using a smoothing coefficient of W = 0.50, exponentially smooth the series and plot the results.
d. What is your exponentially smoothed forecast for 2018?
e. Repeat (c) and (d), using W = 0.25.
f. Compare the results of (d) and (e).
g. What conclusions can you reach about desktop/laptop use by American users?

Year Hours per Day Year Hours per Day 2008 2.2 2013 2.3 2009 2.3 2014 2.2 2010 2.4 2015 2.2 2011 2.6 2016 2.2 2012 2.5 2017 2.1

Step by Step Solution

★★★★★

3.27 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

A Hours 30 25 20 15 10 05 0... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Statistics For Managers Using Microsoft Excel Questions!

The data below(stored in Desktoplaptop) represent the hours per day spent by American desktop/laptop users from 2008 to 2014. a. Plot the time series. b. Fit a three-year moving average to the data...

For the data of Exercise 18.11, fit an exponentially smoothed curve with smoothing constant Î± = 0.4; with smoothing constant Î± = 0.7. Which constant provides more...

For the data of Exercise 18.13, fit an exponentially smoothed curve with smoothing constant Î± = 0.4; with smoothing constant Î± = 0.7. Which constant provides more...

16.4 The data below, stored in Computer Usage , represent the hours per day spent by American desktop and laptop users from 2008 to 2017. Year Hours per Day Year Hours per Day 2008 2.2 2013 2.3 2009...

The data below (stored in DesktopLaptop) represent the hours per day spent by American desktop/ laptop users from 2008 to 2016. a. Plot the time series. b. Fit a three-year moving average to the data...

The data below (stored in DesktopLaptop ) represent the hours per day spent by American desktop/laptop users from 2008 to 2014. a. Plot the time series. b. Fit a three-year moving average to the data...

1. Which elements of its strategy should Netflix stick to and which should it be willing to change to grow in India? 2. Should the company empower Indian managers to make decisions that are right for...

2.2 51 Summarizing Data for a Quantitative Variable Exercises Methods 11. Consider the following data. WEB 14 19 24 19 16 20 24 20 file Frequency a. b. SELF test 21 22 24 18 17 23 26 22 23 25 25 19...

Please Read!!! Please DO NOT copy and past from internet or another student or somewhere else, there is a safe assign program will find any plagiarism...please read the book and write an assignment...

Question: Evaluate the two forecasting models described in the case for predicting daily check-in volume. What are the strengths and weaknesses of each one? Do you find any of the results surprising?...

Using the following information, calculate the expected return and the standard deviation ofABC. | Probability | ABC stock return (%) State of the economy Depression Recession Normal Boom -5 0.15 0.2...

Write a paper about Ingvar Kamprad and the IKEA Company 1. Describe the nature of followership that kamprad seems to have encouraged at ikea. 2. Using the leadership grid and its underlying leader...

4. LO.1 Identify the statutory authority under which each of the following is exempt from Federal income tax. a. Kingsmill Country Club. b. Shady Lawn Cemetery. c. Amber Credit Union. d. Veterans of...

6. An economist might say that colleges and universities produce education, using faculty members and students as inputs. According to this line of reasoning, education is then consumed by...

The data in New Home Sale represent number and median sales price of new single-family houses sold in the United States recorded at the end of each month from January 2000 through April 2012. (Data...

The file Movie Attendance contains the yearly movie attendance (in billions) from 2001 through 2011: a. Construct a time-series plot for the movie attendance (in billions). b. What pattern, if any,...

The file contains the number of audits of corporations with assets of more than $250 million conducted by the Internal Revenue Service between 2001 and 2011. (Data extracted from www.irs.gov.) a....

What is the purpose for using the following techniques?: Factorial ANOVA Multiple Linear Regression Linear Regression Exploratory Factor Analysis

Your company uses large amounts of corn in its production. You have been asked to put together a proposal to hedge exposure to the price of corn. (a) If you expect to use 50,000 bushels of corn in...

Oriental Corporation has gathered the following data on a proposed investment project (lgnore income taxes.): The company uses straight-line depreciation on all equipment. Assume cash flows occur...