Question
The following table contains time series data for regular gasoline prices in the United States for 36 consecutive months: Month Price ($) Month Price
The following table contains time series data for regular gasoline prices in the United States for 36 consecutive months: Month Price ($) Month Price ($) Month Price ($) 2.27 13 2.84 25 3.91 2. 2.63 14 2.73 26 3.68 2.53 15 2.73 27 3.65 4 2.62 16 2.73 28 3.64 2.55 17 2.71 29 3.61 2.55 18 2.80 30 3.45 7 2.65 19 2.86 31 3.38 8 2.61 20 2.99 32 3.27 9. 2.72 21 3.10 33 3.38 10 2.64 22 3.21 34 3.58 11 2.77 23 3.56 35 3.85 12 2.85 24 3.80 36 3.90 (a) Choose the correct line chart for these time series data. What interpretations can you make about the average price per gallon of conventional regular gasoline over these 36 months? (i) Price ($) 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (ii) Price ($) 4.50 4.00 3.50 ww 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (iii) Price ($) 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 7 11 13 15 17 19 21 23 25 27 29 31 33 35 Month 3, (iv) Price ($) 4,50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month - Select your answer Select your answer - Graph (i) Graph (ii) Graph (iii) Graph (iv) (b) Fit a linear trendline to the data. What does the trendline indicate about the price of gasoline over these 36 months? - Select your answer - - Select your answer - Positive non-linear trend Positive linear trend Negative linear trend Negative non-linear trend The following table contains time series data for regular gasoline prices in the United States for 36 consecutive months: Month Price ($) Month Price ($) Month Price ($) 2.27 13 2.84 25 3.91 2. 2.63 14 2.73 26 3.68 2.53 15 2.73 27 3.65 4 2.62 16 2.73 28 3.64 2.55 17 2.71 29 3.61 2.55 18 2.80 30 3.45 7 2.65 19 2.86 31 3.38 8 2.61 20 2.99 32 3.27 9. 2.72 21 3.10 33 3.38 10 2.64 22 3.21 34 3.58 11 2.77 23 3.56 35 3.85 12 2.85 24 3.80 36 3.90 (a) Choose the correct line chart for these time series data. What interpretations can you make about the average price per gallon of conventional regular gasoline over these 36 months? (i) Price ($) 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (ii) Price ($) 4.50 4.00 3.50 ww 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (iii) Price ($) 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 7 11 13 15 17 19 21 23 25 27 29 31 33 35 Month 3, (iv) Price ($) 4,50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month - Select your answer Select your answer - Graph (i) Graph (ii) Graph (iii) Graph (iv) (b) Fit a linear trendline to the data. What does the trendline indicate about the price of gasoline over these 36 months? - Select your answer - - Select your answer - Positive non-linear trend Positive linear trend Negative linear trend Negative non-linear trend The following table contains time series data for regular gasoline prices in the United States for 36 consecutive months: Month Price ($) Month Price ($) Month Price ($) 2.27 13 2.84 25 3.91 2. 2.63 14 2.73 26 3.68 2.53 15 2.73 27 3.65 4 2.62 16 2.73 28 3.64 2.55 17 2.71 29 3.61 2.55 18 2.80 30 3.45 7 2.65 19 2.86 31 3.38 8 2.61 20 2.99 32 3.27 9. 2.72 21 3.10 33 3.38 10 2.64 22 3.21 34 3.58 11 2.77 23 3.56 35 3.85 12 2.85 24 3.80 36 3.90 (a) Choose the correct line chart for these time series data. What interpretations can you make about the average price per gallon of conventional regular gasoline over these 36 months? (i) Price ($) 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (ii) Price ($) 4.50 4.00 3.50 ww 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (iii) Price ($) 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 7 11 13 15 17 19 21 23 25 27 29 31 33 35 Month 3, (iv) Price ($) 4,50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month - Select your answer Select your answer - Graph (i) Graph (ii) Graph (iii) Graph (iv) (b) Fit a linear trendline to the data. What does the trendline indicate about the price of gasoline over these 36 months? - Select your answer - - Select your answer - Positive non-linear trend Positive linear trend Negative linear trend Negative non-linear trend The following table contains time series data for regular gasoline prices in the United States for 36 consecutive months: Month Price ($) Month Price ($) Month Price ($) 2.27 13 2.84 25 3.91 2. 2.63 14 2.73 26 3.68 2.53 15 2.73 27 3.65 4 2.62 16 2.73 28 3.64 2.55 17 2.71 29 3.61 2.55 18 2.80 30 3.45 7 2.65 19 2.86 31 3.38 8 2.61 20 2.99 32 3.27 9. 2.72 21 3.10 33 3.38 10 2.64 22 3.21 34 3.58 11 2.77 23 3.56 35 3.85 12 2.85 24 3.80 36 3.90 (a) Choose the correct line chart for these time series data. What interpretations can you make about the average price per gallon of conventional regular gasoline over these 36 months? (i) Price ($) 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (ii) Price ($) 4.50 4.00 3.50 ww 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (iii) Price ($) 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 7 11 13 15 17 19 21 23 25 27 29 31 33 35 Month 3, (iv) Price ($) 4,50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month - Select your answer Select your answer - Graph (i) Graph (ii) Graph (iii) Graph (iv) (b) Fit a linear trendline to the data. What does the trendline indicate about the price of gasoline over these 36 months? - Select your answer - - Select your answer - Positive non-linear trend Positive linear trend Negative linear trend Negative non-linear trend
Step by Step Solution
3.45 Rating (139 Votes )
There are 3 Steps involved in it
Step: 1
Solution a The answer is Graph iv To construct a line chart in Excel follow the below steps 1 Choose ...Get Instant Access with AI-Powered 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