Question

Provide a statistical trend analysis including a visual graph from Excel with the following information comparing...

Provide a statistical trend analysis including a visual graph from Excel with the following information comparing Toys R Us, Target, and Amazon.

Net Sales in Millions 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
Toys R Us 13,794 13,724 13,568 13,864 13,909 13,543 12,543 12,361 11,802 11,540
Amazon 19166 24509 34204 48077 61093 74452 88988 107006 135987 177866
Target 62884 63435 65786 68466 71960 71279 72618 73785 69495 71879

Homework Answers

Answer #1

Mean S.D.
Toys R Us 13,065 912.07
Amazon 77134.8 51343.01
Target 69158.7 3904.599
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
How can I do regression analysis for Sales Revenue for Macys comparing it to TJX? Please...
How can I do regression analysis for Sales Revenue for Macys comparing it to TJX? Please show work and example in Excel if it's easier. Net Profit Margin 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 Sales Revenue - MACYS $ 15,776,000.00 $ 22,390,000.00 $ 26,970,000.00 $ 26,313,000.00 $    24,892,000.00 $ 23,489,000.00 $ 25,003,000.00 $ 26,405,000.00 $ 27,686,000.00 $ 27,931,000.00 $ 28,105,000.00 $ 27,079,000.00 $ 25,778,000.00 $ 24,837,000.00 Net Profit Margin 2005 2006 2007...
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and...
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data. Calculate the MSE and MAPE for each. Plot the original series, and each of the forecasts. Create forecasts for 2017 Q1, 2017 Q2, 2017 Q3 and 2017 Q4 using each of these three techniques. If you had to choose one of these, which would you choose and why? Given your data, and this time period, would you...
Calculate the annual dividend growth rate for the last 10 years. Kindly provide excel formulas. Based...
Calculate the annual dividend growth rate for the last 10 years. Kindly provide excel formulas. Based on the annual dividend growth rate for data provided, will you forecast a constant or non-constant growth in dividends? Please explain. Date Dividends 8/11/2010 0.303 12/8/2010 0.303 3/9/2011 0.365 5/11/2011 0.365 8/10/2011 0.365 12/7/2011 0.365 3/8/2012 0.398 5/9/2012 0.398 8/8/2012 0.398 12/5/2012 0.398 3/8/2013 0.47 5/8/2013 0.47 8/7/2013 0.47 12/4/2013 0.47 3/7/2014 0.48 5/7/2014 0.48 8/6/2014 0.48 12/3/2014 0.48 3/11/2015 0.49 5/6/2015 0.49 8/5/2015...
JetBlue Airlines Revenue, 2008–2015 (millions) Year Revenue Year Revenue 2008 3,388 2012 4,982 2009 3,286 2013...
JetBlue Airlines Revenue, 2008–2015 (millions) Year Revenue Year Revenue 2008 3,388 2012 4,982 2009 3,286 2013 5,441 2010 3,779 2014 5,817 2011 4,504 2015 6,416 Click here for the Excel Data File (a) Use Excel, MegaStat, or MINITAB to fit both a linear and an exponential trend to the time series. (Round your answers to 2 decimal places.) Linear yt =  t + Exponential yt =  e  t (b) Make annual forecasts for 2016–2018, using the linear and exponential trend models. (Do not...
Provide Ho & Ha for hypothesis testing. What type of hypothesis testing could be used to...
Provide Ho & Ha for hypothesis testing. What type of hypothesis testing could be used to analyze the data and what do the results show? The information is 10 years worth of net sales in the millions. 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 13,794 13,724 13,568 13,864 13,909 13,543 12,543 12,361 11,802 11,540 19166 24509 34204 48077 61093 74452 88988 107006 135987 177866 62884 63435 65786 68466 71960 71279 72618 73785 69495 71879
JetBlue Airlines Revenue, 2008–2015 (millions) Year Revenue Year Revenue 2008 3,388 2012 4,982 2009 3,286 2013...
JetBlue Airlines Revenue, 2008–2015 (millions) Year Revenue Year Revenue 2008 3,388 2012 4,982 2009 3,286 2013 5,441 2010 3,779 2014 5,817 2011 4,504 2015 6,416 (a) Use Excel, MegaStat, or MINITAB to fit both a linear and an exponential trend to the time series. (Round your answers to 2 decimal places.) Linear yt =  t + Exponential yt =  e  t (b) Make annual forecasts for 2016–2018, using the linear and exponential trend models. (Do not round the intermediate calculations. Round your final...
U.S. Civilian Labor Force, 2007-2016 Year Labor Force 2007 153,918 2008 154,655 2009 153,111 2010 153,650...
U.S. Civilian Labor Force, 2007-2016 Year Labor Force 2007 153,918 2008 154,655 2009 153,111 2010 153,650 2011 153,995 2012 155,628 2013 155,151 2014 156,238 2015 157,957 2016 159,640 (d) Make forecasts using the following fitted trend models for years 2017-2019. (Round your answers to the nearest whole number.) t Linear Quadratic Exponential 11 158608 161301 12 159192 163354 13 159776 165653
DETROIT (Y) ANN ARBOR (X) 2008       59                           2008    &
DETROIT (Y) ANN ARBOR (X) 2008       59                           2008       61 2009       60                           2009       58 2010       61                           2010       60 2011       69                           2011       68 2012       66                           2012       67 2013       62                           2013       64 2014       64                           2014       66 2015       71                           2015       70 2016       69                           2016       72 2017       66                           2017       64 h0  :There is a statistical correlation between the temperatures in two different Michigan cities. Please show all five steps of hypothesis testing for regression and correlation analysis. Make sure you show all five steps with...
Please use SPSS for analysis if available Will give positive feedback for answering all questions! Question:...
Please use SPSS for analysis if available Will give positive feedback for answering all questions! Question: The sales data of a company's sales records is provided. a. Plot a time-series plot of the data b. Fit a Linear trend line to these data c. Conduct a hypothesis test of the linear trend model developed in part b. Use significance level of 0.05 d. State the predicted value of sales from 2005 to 2020 e. Calculate MAD and MSE for the...
Table 1. Netherlands’ exchange rates* Years Exchange rates % change 2008 US$1=EUR0.743 N/A 2009 US$1=EUR0.687 -7.53...
Table 1. Netherlands’ exchange rates* Years Exchange rates % change 2008 US$1=EUR0.743 N/A 2009 US$1=EUR0.687 -7.53 2010 US$1=EUR0.752 9.46 2011 US$1=EUR0.761 1.20 2012 US$1=EUR0.762 0.13 2013 US$1=EUR0.73 -4.2 2014 US$1=EUR0.813 11.37 2015 US$1=EUR0.917 12.79 2016 US$1=EUR0.949 3.2 2017 US$1=EUR0.844 -10.5             In five to seven sentences, discuss what the data tells you about your country’s currency.