Answered step by step
Verified Expert Solution
Question
1 Approved Answer
create excel spreadsheet. please give in detail step by step #. Create an Excel table containing the data (shown below) (a) Convert the distance from
create excel spreadsheet. please give in detail step by step
#. Create an Excel table containing the data (shown below) (a) Convert the distance from inch to meter (use =convert(A3, "in", "m") function) (b) Plot the discrete date Air Velocity (m/s) vs. Distance (m) (c) Draw an exponential trendline through the data, and show the trendline equation on the graph. (d) Using the trendline equation find the Air Velocity estimate for a distance of 9 inch (remember the equation is based on data plotted which is in SI units so convert distance to 'm' before substituting into the equation). Distance (inch) Air velocity (m/s) 2.5 8 8 2.2. 8 2 8 22 S 19 16 13 16 1.2 16 1.1 16 1.2 16 1 32 0.5 32 0.4 32 0.5 32 0.5 32 1.5Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started