Question

In: Statistics and Probability

Year Number of Alternative-Fueled Vehicles in US 2000 394,664 2001 425,457 2002 471,098 2003 533,999 2004...

Year

Number of Alternative-Fueled Vehicles in US

2000

394,664

2001

425,457

2002

471,098

2003

533,999

2004

565,492

2005

592,125

2006

634,562

2007

695,766

3. Find the correlation and regression lines for the data above.

r=

LinReg(ax+b)=

Solutions

Expert Solution

Year (X) Vehicles (Y) X * Y
2000 394664 7.89E+08 4000000 1.56E+11
2001 425457 8.51E+08 4004001 1.81E+11
2002 471098 9.43E+08 4008004 2.22E+11
2003 533999 1.07E+09 4012009 2.85E+11
2004 565492 1.13E+09 4016016 3.2E+11
2005 592125 1.19E+09 4020025 3.51E+11
2006 634562 1.27E+09 4024036 4.03E+11
2007 695766 1.4E+09 4028049 4.84E+11
Total 16028 4313163 8.64E+09 32112140 2.4E+12

Correlation



r = 0.996

Equation of regression line is


b = 42235.869



a =( 4313163 - ( 42235.869 * 16028 ) ) / 8
a = -84080418.262
Equation of regression line becomes


orchestra answered 3 years ago
Next > < Previous

Related Solutions

Year Number of Alternative-Fueled Vehicles in US 2000 394,664 2001 425,457 2002 471,098 2003 533,999 2004...
Year Number of Alternative-Fueled Vehicles in US 2000 394,664 2001 425,457 2002 471,098 2003 533,999 2004 565,492 2005 592,125 2006 634,562 2007 695,766 1. Do the variables have significant correlation? For full credit, you must show each step of the hypothesis test. Use the 0.05 significance. 2. In 2008, the price of gas dropped drastically and hit a low average of $1.59 for the nation. What effect do you think this will have on the alternative-fuel car sales, if any?...
Year   Percentage 2000   28 2001   32 2002   36 2003   40 2004   44 2005   51 2006   53...
Year   Percentage 2000   28 2001   32 2002   36 2003   40 2004   44 2005   51 2006   53 2007   57 2008   60 2009   66 Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment. alpha= 0.3 and beta= 0.4. Then calculate MAD. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- Quarter   Price Q1 2017   186.3 Q2 2017   190.9 Q3 2017   195.2 Q4 2017   195.2 Q1 2018   198.7 Q2 2018   201.2 Forecast the price index for Q3 2018 using a​ three-period...
year Percentage 2000 28 2001 32 2002 37 2003 43 2004 47 2005 52 2006 56...
year Percentage 2000 28 2001 32 2002 37 2003 43 2004 47 2005 52 2006 56 2007 58 2008 61 2009 66 Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment. Set alphaα =0.5 and β=0.6
Alternative-Fueled Vehicles The table shows the numbers (in thousands) of alternative-fueled vehicles A in use in...
Alternative-Fueled Vehicles The table shows the numbers (in thousands) of alternative-fueled vehicles A in use in the United States from 1995 to 2011. (Source: U.S. Energy Information Administration) Year Number of vehicles, A 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 246.9 265.0 280.2 295.0 322.3 394.7 425.5 471.1 534.0 565.5 592.1 634.6 695.8 775.7 826.3 938.6 1191.8 (a) Use a graphing utility to plot the data. Let t represent the...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91 $         8.38 $         8.80 $         9.24 $         9.70 $       10.28 $       10.79 $       11.33 $       12.01 Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January​ 1, 2011 price of the stock is $110.00​, determine the current required rate of return for the company​ (use the geometric growth rate to calculate the...
Consider the following price data from 2002 to 2010 Year 2002 2003 2004 2005 2006 2007...
Consider the following price data from 2002 to 2010 Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 Price 3.34 3.56 3.61 4.06 4.25 4.37 4.68 4.59 4.81 a. Compute the simple price index using 2002 as the base year. (Round your answers to 2 decimal places.) Year Price index 2002 2003 2004 2005 2006 2007 2008 2009 2010 b. Update the index numbers with a base year revised from 2002 to 2005. (Round your answers to 2 decimal...
Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 5,974 2002 6,315...
Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 5,974 2002 6,315 2003 7,032 2004 7,006 2005 7,486 2006 8,368 2007 9,932 2008 11,165 (a) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations. Round your final answers to 2 decimal places.) Exponential yt = 5256.1e .0861x (b) Use each of the three...
Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 6,775 2002 7,163...
Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 6,775 2002 7,163 2003 7,848 2004 7,819 2005 8,290 2006 9,205 2007 10,711 2008 12,068 Linear    yt = _______ xt + __________ Quadratic yt = ______ xt^2 + ___________ xt + __________ Exponential yt = __________e-------x Use each pf the three fitted trend equations to make numerical forecasts for the next 3 years. t Linear Exponential Quadratic 9 ? ? ? 10 ? ? ? 11 ?...
Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 6,313 2002 6,647...
Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 6,313 2002 6,647 2003 7,359 2004 7,348 2005 7,778 2006 8,769 2007 10,319 2008 11,633 Click here for the Excel Data File (a) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations. Round your final answers to 2 decimal places.) Linear yt =  xt +...
Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 6,375 2002 6,730...
Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 6,375 2002 6,730 2003 7,441 2004 7,425 2005 7,882 2006 8,758 2007 10,297 2008 12,019 (a) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a minus sign. Do not round the intermediate calculations. Round your final answers to 2 decimal places.) Linear yt = ____ xt + ______   Quadratic yt = ____...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT