Question: The wind chill factor (,) is given as a function of ambient temperature (,) and wind speed (,/): =13.12+0.621511.37^0.16+0.3965^0.16 Using a two-way data table in

The wind chill factor (,) is given as a function of ambient temperature (,) and wind speed (,/): =13.12+0.621511.37^0.16+0.3965^0.16 Using a two-way data table in Excel, develop a wind chill factor table for temperatures between -40 F and 40 F in increments of 10 F (temperatures across the top row of the table) and for velocities from 10 miles per hour (mph) to 100 mph in increments of 10 mph (velocities as a column on the left side of the table). HINT: Note that in the equation above the units for temperature are in C and km/h but your table will have units of F and mph. You may have to look up conversion factors between different units. Your table should present wind chill factor in F and you must use a data table in Excel

Note: please solve it on excel and send me pic and the formula which is being used in cell. Thanks :)

everything is given here. all you need to do is solve this problem on excel

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 Finance Questions!

Need in Java!!!! THANKS IN ADVANCE ! Weather Program in Java Design and create a GUI program for a meteorologist in Java that calculates the wind chill factor and cloud base altitude for inputs of...

Write a program for a meteorologist that calculates the wind chill factor and cloud base altitude for the inputs temperature in Fahrenheit, wind speed in mph, and the dew point in Fahrenheit. Use a...

Code needed in java Weather Program in Java Design and create a GUI program for a meteorologist in Java that calculates the wind chill factor and cloud base altitude for inputs of temperature in...

Modify this c++ code which calculated the wind chill factor and cloud base altitude from inputs of temperature, wind speed, and the dew point, to read the values from a file called weatherData.txt....

CSE 110 Introduction to Computer Science I CSE 110 - Weather Data Program (call-by-reference and void functions) Write a multi-file program for a meteorologist that calculates the wind chill factor...

hi, i am trying to make a java program for my project. the name of the project is weather project. in which i want to calculate the windchill and cloudbase. i made the program but its giving me a...

out your own 3. You must submit your lab quiz file(s) to moodle before 10:00pm, Feb.4, 2019. 4. At the top of each fle introduce your name and student ID. 5. Document your codes/commands well....

I have this computer scince assignement that need to be done using c++. preferably by using Unix puTty Programming Assignment #2 CS 120 Bruce Bolden 10 Points June 19, 2017 Due: June 23, 2017...

could you put steps and screenshots to help my to know the way do coding however, the C++ is a new thing for my. Objective: Become more familiar with C++ I/O, computations in C++, and the C++...

Determine the internal actions at a cross-section through point A. First use section to the right of A, and then by looking at section to the left of A. Set a = 1 m, q = 30, M = 1 kN.m, P = 1 kN M B...

The following transactions were selected from among those completed by Bear's Retail Store: November 20 Sold two items of merchandise to Cheryl Jahn, who paid the $1,700 sales price in cash. The...

Schedule of Cost of Goods Manufactured Balance Sheet - Inventory Levels Contribution Approach Income Statement The model should allow me to change the following inputs: Units Produced Units Sold DM...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...