Question: 20. (**) (Microsoft Excel problem) Wayne Banker is in charge of planning water usage for agriculturally intensive Burke County, August is the peak month of

20. (**) (Microsoft Excel problem) Wayne Banker is in charge of planning water usage for agriculturally intensive Burke County, August is the peak month of water usage for Burke County, Wayne has collected the following statistics from the past 15 years, showing the total March-June rainfall (in inches), average daily high temperature in July, and number of acre-feet of water used in August by farms in the area. Wayne wants to know if he can predict how much water will be needed in August, given the March June rainfall and July temperature data YEAR INCHES OF RAINFALL MARCH-June AVERAGE PEAK DAILY TEMPERATURE. JULY ACRE-FEET OF WATER USED, AUGUST 2005 12.5 78.4 39,800 2006 74.9 43,700 2007 841 45,100 2008 54,500 2009 32,900 2010 31,500 2011 35,500 2012 35,800 2013 89,700 88 2014 48,100 2015 53,700 2016 40,300 2017 81.5 32,600 2018 770 34,100 2019 36.800 Use Excel's regression function to develop a multiple regression forecast for Wayne. What is the R for the model? Use the model to forecast water usage for 2005-2019. Calculate the MFE and MAPE for the model. In your opinion, how good is the model

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

=+20. (***) (Microsoft Excel problem) Wayne Banker is in charge of planning water usage for agriculturally intensive Burke County. August is the peak month of water usage for

21. (***) (Microsoft Excel problem). Wayne Banker is in charge of planning water usage for agriculturally intensive Burke County. August is the peak month of water usage for Burke County.Wayne has...

Use Excel's regression function to develop a multiple regression forecast. Please fill out all the yellow cells( F, FE, MFE, AD, MAD, APE, MAPE, TS) and show your work. Thank you! (***) (Microsoft...

Wayne Banker is in charge of planning water usage for agriculturally intensive Burke County. August is the peak month of water usage for Burke County. Wayne has collected the following statistics...

Loretta Racker is in charge of planning water usage for agriculturally intensive Racker County. August is the peak month of water usage for Racker County. Loretta has collected the following...

20. (***) (Microsoft Excel problem). Using regression analysis, develop a forecasting model with monthly seasonal indices for Cooper Toys. Forecast demand for each of the months in the six-month...

Performance Qualifier level (minimum requirements) 99.9% pure 99% pure Order qualifier Conformance quality Are the chemicals pure? 2 days 3 days Delivery speed How quickly can the chemicals be...

Instructions This assignment ( take - home quiz ) is worth 1 5 points and contains 2 problems. This is an individual assignment ( no groups ) . Any signs of cheating will result in a zero score for...

you are planning to form a new Student Club at Open Campus next semester. You are currently working on recruiting club members and adverting your club activities. You will be working on three...

List three points indicating that the situation above violates the relevant professional and ethical requirements relating to audit engagements (general standard of GAAS). Do not comment on the...

Repeat Prob. 14-67 for a heat removal rate of 950kJ/min. Prob. 14-67 Air enters a 30-cm-diameter cooling section at 1 atm, 35oC, and 45 percent relative humidity at 18 m/s. Heat is removed from the...

A not - for - profit arts organization receives a $ 3 0 0 , 0 0 0 gift from a donor who specifies that the gift must be maintained in perpetuity, and the income from the gift is to be used only to...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...