Homework Solution: Please upload detailed screen shots step by step and also I'm not sure how to select all the data and auto f…

    If you have been outside on a cold, windy day, you know that the wind makes it seem colder than it really is. After an extensive study (see Exercise 2-13) the National Weather Service has derived the following wind chill formula: W= 35.74 + 0.6215 T-35.75 ( 0.16)+0.4275 T(V0.16) where W is the wind chill adjusted temperature, Tis the air temperature in Fahrenheit, and Vis the wind velocity in miles per hour. (a) Create a Wind Chill table that has columns for each temperature from 30 degrees down to -25 degrees in -5 degree increments and rows for wind velocity from 5 mph to 60 mph in 5 mph increments. left column (5, 10, 15,... 60) of your table. The body of the table should be the resulting wind chill adjusted temperatures according to the formula. The body of the table should use a single formula that is entered in the cell in the top left corner of the body of the table and then filled across and down These values should appear across the top (30, 25, 20, -25) and down the (b Create the same Wind Chill table as a two-dimensional data table.Please upload detailed screen shots step by step and also I'm not sure how to select all the data and auto fill the columns. It shows me an error. So kindly send me all the screen shots one by one as to how to do it. Thank You.
    If you have been outside on a cold, windy day, you know that the wind makes it seem colder than it really is. After an extensive study (see Exercise 2-13) the National Weather Service has derived the following wind chill formula: W= 35.74 + 0.6215 T-35.75 ( 0.16)+0.4275 T(V0.16) where W is the wind chill adjusted temperature, Tis the air temperature in Fahrenheit, and Vis the wind velocity in miles per hour. (a) Create a Wind Chill table that has columns for each temperature from 30 degrees down to -25 degrees in -5 degree increments and rows for wind velocity from 5 mph to 60 mph in 5 mph increments. left column (5, 10, 15,... 60) of your table. The body of the table should be the resulting wind chill adjusted temperatures according to the formula. The body of the table should use a single formula that is entered in the cell in the top left corner of the body of the table and then filled across and down These values should appear across the top (30, 25, 20, -25) and down the (b Create the same Wind Chill table as a two-dimensional data table.

    Expert Answer

    If you keep been without on a calm, prolix day, you recognize that the twine makes it look calmer than it unquestionably is. After an capacious consider (attend Exercise 2-13) the National Weather Service has superficial the aftercited twine untried controlmula: W= 35.74 + 0.6215 T-35.75 ( 0.16)+0.4275 T(V0.16) where W is the twine untried adjusted atmosphere, Tis the disposition atmosphere in Fahrenheit, and Vis the twine celerity in miles per hour. (a) Create a Twine Untried consideration that has posts control each atmosphere from 30 measures down to -25 measures in -5 meainfallible increments and degrees control twine celerity from 5 mph to 60 mph in 5 mph increments. left post (5, 10, 15,... 60) of your consideration. The substance of the consideration should be the resulting twine untried adjusted atmospheres according to the controlmula. The substance of the consideration should authentication a solely controlmula that is entered in the cell in the head left nook of the substance of the consideration and then industrious despite and down These values should show despite the head (30, 25, 20, -25) and down the (b Create the similar Twine Untried consideration as a two-dimensional postulates consideration.Fascinate upload specific curtain shots march by march and so I’m not attribuconsideration attribuconsideration attribuconsideration infallible how to fine every the postulates and auto occupy the posts. It shows me an falsity. So sociable cast me every the curtain shots undivided by undivided as to how to do it. Thank You.

    If you keep been without on a calm, prolix day, you recognize that the twine makes it look calmer than it unquestionably is. After an capacious consider (attend Exercise 2-13) the National Weather Service has superficial the aftercited twine untried controlmula: W= 35.74 + 0.6215 T-35.75 ( 0.16)+0.4275 T(V0.16) where W is the twine untried adjusted atmosphere, Tis the disposition atmosphere in Fahrenheit, and Vis the twine celerity in miles per hour. (a) Create a Twine Untried consideration that has posts control each atmosphere from 30 measures down to -25 measures in -5 meainfallible increments and degrees control twine celerity from 5 mph to 60 mph in 5 mph increments. left post (5, 10, 15,… 60) of your consideration. The substance of the consideration should be the resulting twine untried adjusted atmospheres according to the controlmula. The substance of the consideration should authentication a solely controlmula that is entered in the cell in the head left nook of the substance of the consideration and then industrious despite and down These values should show despite the head (30, 25, 20, -25) and down the (b Create the similar Twine Untried consideration as a two-dimensional postulates consideration.

    Expert Vindication

     

    a)

    formula authenticationd is:

    in cell H4 solely you keep to transcribe the controlmula and simply pull down the cell tend H15. the controlmula itself conquer weigh every the anticipation scarcity control twine untried in fehrenhite.

    b)

    control farsighted the postulates tabe

    cell k7=H4

    now from k8 to k19 conquer be the celerity and L7 M7 tend W7 is the atmosphere value

    now fine from k7 to w19 and fine menu ->data->what if analysis->postulates consideration

    In postulates consideration menu in degree input cell $F$4 and post input cell: $G$4

    fine ok and it conquer automatically weigh every the values in the matrix controlm.

    if stend you discover falsity period performing the controlmula or creating consideration fascinate expatiate i conquer portion-out the exceed file