Number 5
AutoSave On Money - Last Modified: Tue at 5:01 PM Valerie Moore X Search View Help Share Comments File Home Insert Draw Page Layout Formulas Data Review Insert Arial 10 A A ab General 2" Ap O Delete Conditional Format as Cell Sort & Find & Analyze Paste BIUVV DAY I V $ ~ % 9 508 2. Formatting Table Styles v Format Filter Select Data Cells Alignment Styles Analysis Font Number Editing Clipboard A1 X V fx M N 0 P Q R S V W X AA AB AC AD B C D E F G H K Consumer Prices, Capacity Utilization, Money Supply, and Unemployment (n = 41, k = 4) Year ChgCPI CapUtil ChgM1 ChgM2 Unem 1966 2.9 91.1 2.5 4.6 3.8 LearningStats NOMIA WN 1967 3.1 37.2 6.6 9.3 3 . 8 7.7 Copyright @ 2019 1968 4.2 87 1 8.0 3 .6 1969 5.5 86.6 3.3 3.7 The McGra w-Hill Companies 1970 5.7 79 4 5.1 6.6 4.9 4.4 77.9 6.5 13.4 5.9 This spreadsheet is intended solely 1971 1972 9.2 for educational pu 3.2 83.3 13.0 5 .6 licensed users of Connect 1973 6.2 87.6 5.5 6.6 4.9 1974 11.0 84 4 4.3 5.4 5 .6 1975 9.1 73.5 4.7 12.6 8.5 197 5.8 78.2 6.7 13.4 7.7 1977 6.5 82.4 8.1 10 3 Source: Economic Report of the President, 2007. 1978 7.6 84.3 8.0 7.5 6.1 1979 11.3 84.2 6.9 7.9 5 .8 1980 13. 78.7 70 8.6 7.1 Variable Names: ChCPI = percent change in the 1981 10.3 77.0 6.9 9.7 Consumer Price Index (CPI) over previous year, 71.0 8.7 8.8 9.7 CapUtil = percent utilization of manufacturing capacity 21 1983 3.2 73.5 9.8 11.3 in current year, ChgM1 = percent change in currency 1984 4.3 79.4 5.8 8.6 7.5 and demand deposits (M1) over previous year, ChgM2 = percent change in small time deposits and other 1985 3 .6 78.3 12.4 8.0 7.2 near-money (M2) over previous year, Unem = civilian 1986 1.9 78 4 16.9 9.5 7.0 3.6 80.9 3.5 3.6 6.2 unemployment rate for all workers. 1988 4.1 83.9 4.9 5.8 5.5 1989 4.8 83.1 08 5.5 5.3 1990 5.4 $1.6 4.0 3.8 5 .6 1991 4.2 78.3 8.8 3.1 6.8 1992 3.0 79.4 14.3 1.6 7.5 1993 3.0 80.3 10.2 6.9 2.6 82.8 1.8 0.4 6.1 1995 2.8 33.1 -2.0 4.1 5.6 1996 3.0 81.9 -4.1 4.8 5.4 1997 2.3 83.0 - 0.7 5.7 4.9 1998 81.7 2.1 8.6 4.5 1999 80 8 6.0 4.2 2000 3.4 80.1 6.0 4.0 2 .8 73.9 10.4 4.7 2002 1.6 73.0 3.2 6.3 5 .8 2003 2.3 74.2 7.1 5.0 6 . 0 2004 2.7 76.6 5.3 5.8 5.5 2005 3.4 78.8 - 0.2 4.0 5 .1 2006 3.2 80.4 5.3 46 D Data Extra Sheet + m + 60% Ready 12:21 AM Type here to search O EI X 77.F Mostly cloudy ~ 9 0 ( 41) 8/3/2021Home X Gradebook X Question 5 - X * Search Resul Course Hero X V X - C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&... Q . . . Wk 5 - Practice: Wk 5 Exercises [due Day 5] i Saved Help Save & Exit Submit Check my work 5 picture Click here for the Excel Data Set Dj Rerun the regression requesting variance inflation factors (VIFs) for your predictor.' 2 (a) Fill in the values for the table below. (Round your answers to 3 decimal places.) points Variables VIF Intercept eBook CapUtil ChgM1 References ChgM2 Unem (b) Data set D has no potential multicollinearity problem. Is the statement true? O Yes O No (c) Data set D has O potential multicollinearity problems because VIF > 10 no potential multicollinearity problems because VIF Type here to search O 77.F Mostly cloudy ~ ( * ( 41) 12:21 AM 8/3/2021
