Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do you filter this data in Excel using 2 different moving averages? From left to right is the wind speed, normal force, side force,

How do you filter this data in Excel using 2 different moving averages? From left to right is the wind speed, normal force, side force, axial force, pitch moment, yaw moment, roll moment, pressure, and pitch angle.
\table[[Ball],[Speed mph,NF/lbf,SF/lbf,AF/lbf,PM/in-lb,YM/in-lb,RM/in-lb,P1/in-wc,Pitch/deg],[30,-0.0038,-0.0986,0.0084,-0.0609,-0.3942,0.0000,0.4055,0.0603],[40,0.0295,-0.2554,0.0772,-0.2159,-0.4759,0.0000,0.9738,0.0601],[50,-0.1236,-0.3610,0.2288,-0.2599,-1.1907,0.0000,1.6442,0.0600],[60,-0.1494,-0.4396,0.4388,0.1764,-1.8734,0.0000,2.8458,0.0600],[70,0.0503,-0.6009,0.6409,0.9734,-2.4435,0.0000,3.8700,0.0600],[80,0.1696,-0.7443,0.8655,1.3297,-2.8879,0.0000,4.8839,0.0600],[90,0.5049,-0.5755,1.0040,1.7350,-2.1765,0.0000,6.0189,0.0600]]
\table[[Car,],[Speed mph,NF/lbf,SF/lbf,AF/lbf,PM/in-lb,YM/in-lb,RM/in-lb,P1/in-wc,Pitch/deg],[30,-0.1382,0.0035,0.1925,-1.5100,0.0619,0.0000,0.5199,0.0600],[40,-0.3209,0.0105,0.4084,-3.5431,0.1331,0.0000,1.1721,0.0600],[50,-0.5984,0.0122,0.6826,-6.4584,0.1719,0.0000,2.1199,0.0600],[60,-1.0242,0.0248,1.1336,-10.9310,0.3850,0.0000,3.5407,0.0600],[70,-1.2304,0.0225,1.3604,-13.2032,0.3953,0.0000,4.2306,0.0600],[80,-1.8413,0.0374,2.0077,-19.5732,0.6112,0.0000,6.2846,0.0600],[90,-2.4863,0.0635,2.6739,-26.4566,0.8856,0.0000,8.4865,0.0600]]
\table[[Train,],[Speed mph,NF/lbf,SF/lbf,AF/lbf,PM/in-lb,YM/in-lb,RM/in-lb,P1/in-wc,Pitch/deg],[30,0.0348,0.0379,-0.0595,-0.5912,-0.2086,0.0000,0.3687,0.0600],[40,-0.0301,0.0705,0.2797,-1.4881,-0.4089,0.0000,1.2519,0.0600],[50,-0.1113,0.0925,0.5930,-2.2453,-0.5194,0.0000,2.0280,0.0600],[60,-0.2230,0.1591,1.0324,-3.2031,-0.7021,0.0000,3.1228,0.0600],[70,-0.3059,0.2390,1.4211,-4.1694,-0.9689,0.0000,4.1510,0.0600],[80,-0.5143,0.3525,2.3327,-6.3800,-1.2799,0.0000,6.4597,0.0600]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analytics Systems Engineering Cybersecurity Project Management

Authors: Christopher Greco

1st Edition

168392648X, 978-1683926481

More Books

Students also viewed these Databases questions

Question

Does the familiar material appear first in each sentence? (452)

Answered: 1 week ago

Question

What is the difference between narcolepsy and sleep apnea?

Answered: 1 week ago