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 linear trend forecasts developed

DATASET:

Year | Sales |

2005 | 878 |

2006 | 983 |

2007 | 1085 |

2008 | 1276 |

2009 | 1502 |

2010 | 1738 |

2011 | 2044 |

2012 | 2238 |

2013 | 2388 |

2014 | 2488 |

2015 | 2978 |

2016 | 3267 |

2017 | 3375 |

2018 | 3575 |

2019 | 3866 |

2020 | 3980 |

Answer #1

The time series plot is

b) The linear model is

Sales=442548-221.07(year)

C) the hypothesis is

H0:-slope=0

The regression Coefficient is equal to zero

D)

H1:- slope=/0

The regression coefficient is not equal to zero

D)the preadicate values is

E) the value of MAD is 885.76

And MSE is 1.567

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 11 minutes ago

asked 12 minutes ago

asked 17 minutes ago

asked 38 minutes ago

asked 49 minutes ago

asked 52 minutes ago

asked 52 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago