Please assist with these problems and use two separate Excel for each problem. The same attached file information is used for both problems.
1.Using the water use data set analyze the data using Excel and report in proper statistical form/jargon about the dataset.
2. Using the water use data set analyze the data using Excel to perform a regression analysis to (1)predict (2)describe and (3)control, and report each in proper statistical form/jargon.
Excel and Word attachments process water use data given to create a report that predicts and describes the dataset.