Lowes Companies, Inc., is a home improvement company offering a range of products for maintenance, repair, remodeling, and decorating. Lowes has enjoyed a steady growth in revenue. The data set (Q1_Revenue_Lowes.jmp) contains quarterly data on Lowes revenue (in $ million) with its fiscal year concluding at the end of January.

IF YOU CAN HELP WITH ANY OF THE QUESTIONS I WOULD GREATLY APPRCIATE IT

1) Create a time series plot in JMP and upload a screenshot (jpg, jpeg, png, pdf) of it below.

2) Estimate a linear trend model without seasonality. Upload a screenshot (jpeg, jpg, png, pdf) of the output of JMP showing the regression coefficients.

3) Write down the equation for the linear trend model without seasonality created above.Revenue = (enter answer) + enter answer

4)

Estimate a linear trend model with seasonality. Upload a screenshot (jpeg, jpg, png, pdf) of the output of JMP showing the regression coefficients

(Use Quarter 4 as the reference category/class when creating the dummy variables)

5) Write down the equation for the linear trend model with seasonality created above.

Revenue = blank + blank(trend) + blank (quarter1) + blank (quarter2)+ blank (quarter3)

6) Compare the models developed during step b and step e. Which model is preferred?

-Linear Trend Only

-Linear Trend with Seasonality

7) Use the preferred model to forecast Lowes revenue for the fourth quarter of 2018 and the first quarter of 2019.

Revenue for 4th Quarter of 2018:

Revenue for 1st Quarter of 2019:

Year Quarter Revenue Year Quarter Revenue Year Quarter Revenue Year Quarter Revenue