Calculate the Wind Chill given the inputs of Temp and Wind Speed

In this problem, you will calculate the Wind Chill given the inputs of Temperature and Wind Speed. You will also provide the results as line and column charts.

1) Start Excel. Download and open the workbook named:
Chapter_1-7_Wind_Chill_Start
2) In cell C10, use the appropriate formula to calculate the Wind Chill.
3) In cell D17, use the appropriate formula to calculate the Wind Chill if Temperature is equal to the value in cell C17 and Wind Speed is equal to the value in cell D16. Fill cell D17 down and across to cell M26.
Note: Be sure to use absolute, mixed, and relative cell references.
4) In cells B37:J53, insert a Line Chart to show Wind Chill as a function of Temperature 13°F. Select ranges D16:M16 and D24:M24. On the Insert tab, click Recommended Charts, and then click Line. Apply Style 1 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Wind Chills (˚F) for Temperature 13 ˚F. Add axis titles. Replace Axis Title for the horizontal axis with Wind Speed (mph) and Axis Title for the vertical axis with Wind Chills (˚F).
5) In cells L37:T53, insert a Clustered Column Chart to show Wind Chill as a function of Wind Speed 9 mph. Select ranges C17:C26 and H17:H26. On the Insert tab, click Recommended Charts, and then click Clustered Column. Apply Style 6 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Wind Chills (˚F) for Wind Speed of 9 MPH. Add axis titles. Replace Axis Title for the horizontal axis with Temperatures (˚F) and Axis Title for the vertical axis with Wind Chills (˚F).
6) Save your file and submit.

Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.

Wind chill is a function of the outside temperature (˚F) and the wind speed (mph):
Wind Chill(◦F) = 35.74+0.6215*Temp(◦F) - 35.75*Speed(mph)0.16 + 0.4275*Temp(◦F)*Speed(mph)0.16

a.) Enter a formula that outputs the Wind Chill given the inputs of Temperature and Wind Speed.

b.) Enter a formula in the 10 by 10 table that gives one hundred wind chill outputs for the ten Temperature inputs and ten Wind Speed inputs. Be sure to use proper absolute/mixed/relative cell references

c.) Create 2 graphs:
1. Line chart showing Wind Chill as a function of Temperature 13°F .
2. Column chart showing Wind Chill as a function of Wind Speed 9 mph.
Axis titles and labels should be chosen from the list:
a. Wind Chills (˚F) for Wind Speed of 9 MPH
b. Wind Speed (mph)
c. Temperatures (˚F)
d. Wind Chills (˚F)
e. Wind Chills (˚F) for Temperature 13 ˚F