Provide a statistical trend analysis on the following data. Show this in a visual graph using...

Provide a statistical trend analysis on the following data. Show this in a visual graph using excel. Explain in detail the trend comparing Toys R Us to the other two corporations, Amazon and Target. Can this information be used to provide future trends in sales and possibly prevented bankruptcy for Toys R Us. Do you see any underlying patterns or behaviors?

Net sales   In millions (other than stores)
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 Toys R Us
19166   24509   34204   48077   61093   74452   88988   107006   135987   177866 Amazon
62884   63435   65786   68466   71960   71279   72618   73785   69495   71879 Target

Expert Solution

S.No.	year	R Us	Amazon	Target
1	2008	13794	19166	62884
2	2009	13724	24509	63435
3	2010	13568	34204	65786
4	2011	13684	48077	68466
5	2012	13909	61093	71960
6	2013	13543	74452	71279
7	2014	12543	88988	72618
8	2015	12361	107006	73785
9	2016	11802	135987	69495
10	2017	11540	177866	71879

FROM THE ABOVE GRAPH IT IS CLEAR THAT

Net sale in R Us is almost same for every year. It seems that there is very little decline in net sale of R Us year to Year. So there is very small fluctuation (ups and down) in sale.
In Target there is small increment of net sale year by year.
Net sale of Amazon increasing very rapidly year by year.

COMPARISON

Yearly net sale of Target is larger than R Us but both have not very fast increment of sale but initially (2008) Amazon's net sale is nearly equal to R us but due to continuously rapid increment Amazon yearly net sale become much much larger to both corporation.

PREDICTIONS

In future years , it seems from data R Us yearly net sale lies between 11,500 million to 12,500 million.
similarly for Target , yearly net sales lies between 67000 million to 73000 million and not have much more ups and down.
Amazon's net increasing very fast and it seems that in future year it will cross 200,000 million per year

THIS IS ANOTHER FORMAT OF GRAPH WHICH CLEAR YOU MORE

thanks

orchestra answered 2 years ago

Please show all steps using data set below and excel. By using a bivariate regression trend...

Please show all steps using data set below and excel. By using a bivariate regression trend line model, forecast total houses sold for the next five years. Prepare a time series plot of these data (years are on the x axis, THS is on the y axis) that shows both actual and forecast THS for the next five years. Total Houses Sold Year Northeast 1996 74.00 1997 78.00 1998 81.00 1999 76.00 2000 71.00 2001...

Using the below data I need a statistical formula to show which of these categories a...

Using the below data I need a statistical formula to show which of these categories a total of 50 people did the best in in a memory test of words vs. pictures vs. numbers or if it is statistically not able to be proven "reject the null hypothesis" Words Out of 20 Male & Female N=50 Pictures out of 18 Male & Female N=50 Numbers out of 18 Male & Female N=50 Words Pictures Numbers 16 17 12 15 16...

Trend Analysis - The following data pertain to Company A: (in millions) Year 2 Year 1...

Trend Analysis - The following data pertain to Company A: (in millions) Year 2 Year 1 Revenue $39,474 $35,137 Net income 5,658 5,642 Accounts receivable 4,389 3,725 Inventory 2,290 1,926 Total current assets 10,151 9,130 Total assets 34,628 29,930 Total current liabilities 7,753 6,860 Total long-term liabilities 9,641 7,702 Total stockholder equity 20,000 18,000 Common-Size Income Statements - Company A reported the following income statements: COMPANY A INCOME STATEMENT FOR THE YEARS ENDED DECEMBER YEAR 2 AND YEAR 1 (in...

5) Draw the trend analysis based on following sales data for four years and analyse the...

5) Draw the trend analysis based on following sales data for four years and analyse the fifth-year projected sales. Mention the possible relationship between the sales and the year on the basis of linear regression. Also mention the R-square value and its interpretation. Year Sales 1 900 2 1100 3 1200 4 1450 5

Regression analysis is an important statistical method for the analysis of business data. It enables the...

Regression analysis is an important statistical method for the analysis of business data. It enables the identification and characterization of relationships among factors and enables the identification of areas of significance. The performance and interpretation of linear regression analysis are subject to a variety of pitfalls. Comment on what these pitfalls may be and how you would avoid them. Use an example if it helps to clarify the point.

SOLVE THE FOLLOWING USING STATISTICAL SOFTWARE R. SHOW YOUR CODE AND ANSWERS, USING AN RMD FILE...

SOLVE THE FOLLOWING USING STATISTICAL SOFTWARE R. SHOW YOUR CODE AND ANSWERS, USING AN RMD FILE (SHOW ANSWERS IN R MARKDOWN FORWAT WITH CODE AND ANSWERS) PROBLEM 1 A study of 400 glaucoma patients yields a sample mean of 140 mm and a sample standard deviation of 25 mm for the the following summaries for the systolic blood pressure readings. Construct the 95% and 99% confidence intervals for μ, the population average systolic blood pressure for glaucoma patients. PROBLEM 2...

Trend Analysis - The following data pertain to Company B: (in thousands) Year 2 Year 1...

Trend Analysis - The following data pertain to Company B: (in thousands) Year 2 Year 1 Revenue $1,285,876 $1,364,550 Net income 56,644 42,906 Accounts receivable 149,178 168,666 Inventory 158,541 179,688 Total current assets 670,337 649,903 Total asset 859,907 849,399 Total current liabilities 227,807 232,074 Total long-term liabilities 36,483 40,787 Total stockholder equity 595,617 576,538 Common-Size Income Statements - Company B reported the following income statements: COMPANY B INCOME STATEMENT FOR THE YEARS ENDED DECEMBER YEAR 2 AND YEAR 1 (in...

Draw the trend analysis based on following sales data for four years and analyse the fifth-year...

Draw the trend analysis based on following sales data for four years and analyse the fifth-year projected sales. Mention the possible relationship between the sales and the year on the basis of linear regression. Also mention the R-square value and its interpretation. Year Sales 1 900 2 1100 3 1200 4 1450 5

Using a graph, show how each of the following labor markets (assumed to be competitive and...

Using a graph, show how each of the following labor markets (assumed to be competitive and initially in equilibrium) is affected by the following changes. Explain your reasoning fully. 1.Labor market for workers who completed high school only.The workplace becomes more computerized and technically sophisticated. 2.Labor market for workers who completed college or more.The workplace becomes more computerized and technically sophisticated.

Estimate a linear time trend for the Netflix data using data for the period 2000Q1 ......

Estimate a linear time trend for the Netflix data using data for the period 2000Q1 ... Estimate a linear time trend for the Netflix data using data for the period 2000Q1 to 2008Q4. a. Carry out a preliminary analysis of the data including a line fit plot and interpret your results. b. Test whether the slope is significantly different from zero, using alpha = 0.05. c. Compute S and R2 and interpret the results. d. Compute point forecasts for sales...

Question