Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AutoSave O Off) US_Gas_Price (1) - Protected View . Search (Alt+Q) isaiah rucker X File Home Insert Draw Page Layout Formulas Data Review View Help

image text in transcribed
AutoSave O Off) US_Gas_Price (1) - Protected View . Search (Alt+Q) isaiah rucker X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments 1PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 X V fx Average US Gas Price 1991-2015 (in dollars per gallon) A B C D E F G H J K L M N O P Q Year Average US Gas Price 2 Period Moving Average 3 Period Moving Average 3 1991 1.140 N/A N/A 4 1992 1.130 1.135 N/A 5 1993 1.110 1.120 1.1271 6 1994 1.110 1.110 1.117 7 1995 1.150 1.130 1.123 8 1996 1.230 1.190 1.163 9 1997 1.230 1.230 1.203 10 1998 1.060 1.145 1.173 11 1999 1.170 1.115 1.153 12 2000 1.510 1.340 1.247 13 . 2001 1.460 1.485 1.380 14 2002 1.360 1.410 1.443 15 2003 1.590 1.475 1.470 16 : 2004 1.880 1.735 1.610! 17 2005 2.300 2.090 1.923 18 . 2006 2.590 2.445 2.257 19 2007 2.800 2.695 2.563 20 2008 3.270 3.035 2.887 21 . 2009 2.350 2.810 2.807- 22 - 2010 2.790 2.570 2.803- 23 2011 3.530 3.160 2.890 24 2012 3.640 3.585 3.320 25 2013 3.530 3.585 3.567 26 2014 3.370 3.450 3.513. 27 - 2015 2.450 2.910 3.1171 Sheet1 Ready Average: 517.7480584 Count: 105 Sum: 50221.56167 + 100% H Type here to search a 80.F 11:24 PM 6/27/2021

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

Step: 3

blur-text-image

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

Differential Equations For Engineers

Authors: Wei Chau Xie

1st Edition

0511771037, 9780511771033

More Books

Students also viewed these Mathematics questions

Question

understand the restrictions of top-down job redesign approaches;

Answered: 1 week ago

Question

Sell the quality of your brand or products.

Answered: 1 week ago