Build a good speesheet and regression model

I’m working on a Excel question and need guidance to help me study.

1. The attached “Excle 1” spreadsheet contains information about four employees working together in a particular department. It has been created very poorly. Use the principles of building “good” spreadsheets to “fix” the spreadsheet (make it more usable, easily understood, and appealing).

There are six-issue to addressed, also need the aesthetic improvement

2. Use the attached data to build a regression model for a DSS in Excel to predict log10 APC levels from UV light readings. Use good spreadsheet engineering principles. Include: R-sqaure, F and t Hypothesis Tests (for model and slope), the MAPE for the test data, and confidence intervals for a predicted point (prediction intervals).

(1). properly using test and training data sets

(2). R-square, F and t-tests

(3). MAPE for test data

(4). confidence intervals

(5). Make sure the spreadsheet a working decision support system with good spreadsheet principles applied