Reference no: EM133925615

You are required to complete the given activities and to write a reflection piece to demonstrate your understanding of the concepts learned during this session. You will submit this reflection as part of the A1 Portfolio: Reflection 3 assessment.

Part 1

Activity 1

Instructions:

Apply multiple linear regression using the "Bank Salaries" dataset provided in the Session 5 datasets folder.

Interpret the sign and the value of the estimated coefficients

Activity 2

Instructions:

Using the "House Sales" dataset provided in the Session 5 datasets folder, perform moving average and exponential smoothing forecast techniques. For each method, calculate MAE, RMSE and comment on the performance of each method. Get expert-level assistance in any subject with our assignment help services.

Part 2

Activity 1

Instructions:

A farmer in NSW owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $2000 profit, requires three workers and requires two tons of fertilizer. Each acre planted with corn yields $3000 profit, requires two workers and requires four tons of fertilizer. There are currently 1000 workers and 1200 tons of fertilizer available.

Use Solver to help the farmer maximise the profit from his land.
Confirm graphically that the solution from part a maximises the farmer's profit from his land.