Please see attached
Analyzing and understanding data is an important part of decision making. Econometrics is defined as the statistical methods used to analyze data and make informed decisions. For this assignment, you are required to research data related to an economic issue or situation relevant to your organization or a business organization in general. Use the Bureau of Economic Analysis website to choose data for this assignment. In addition, review the articles in Topic Materials relating to econometrics. Analyze the data you have selected to determine how to use them to make appropriate economic decisions for an organization. As you are analyzing the data, apply econometrics methods (linear regression, statistical mathematics, nonlinear regression, or another relevant model) to validate data and determine strategies and solutions for the economic data retrieved. Please review the “Sample Econometrics Problem” resource to assist you in completing this assignment.
Write a summary (500-750 words) to discuss your data findings and the proposed solutions generated based on applying econometrics and analyzing the data. You are required to submit the selected data, methods for testing and validating data, and the economic decisions you have established based on analysis of the data.
Prepare this assignment according to the guidelines found in the APA Style Guide. An abstract is not required.
>Sheet pch Percent Change q Monthly /01/ 0
9-01-01 to – -01
03/01/19 19 -01-01 to 2015-11-01 US. Bureau of Economic Analysis date value 0
01/01/1970 /01/1970
04/01/1970 1.6 07/01/1970 /01/1970
10/01/1970 1.0 01/01/1971 04/01/1971 07/01/1971 1.2 10/01/1971 0.5 01/01/1972 1.0 04/01/1972 1.9 07/01/1972 2.4 10/01/1972 01/01/1973 04/01/1973 1.9 07/01/1973 10/01/1973 1.8 01/01/1974 2.1 04/01/1974 3.2 07/01/1974 3.1 10/01/1974 1.0 01/01/1975 04/01/1975 2.9 07/01/1975 0.8 10/01/1975 1.2 01/01/1976 3.1 0.5 04/01/1976 1.8 0.7 07/01/1976 10/01/1976 2.9 01/01/1977 SUMMAR
1
DSPIC
9
6
PCE
pch
Percent Change
q
Monthly
0
3
19
7
19
5
20
15
11
70
59
Real Disposable Personal Income
Personal Consumption Expenditures
US. Bureau of Economic Analysis
date
value
01/01/1
97
1.0
1.
8
0
4
1.2
1.6
07/01/1970
1.9
10
–
0.3
01/01/19
71
2.0
2.9
04/01/1971
1.5
2.1
07/01/1971
0.5
1.8
10/01/1971
2.3
01/01/19
72
2.4
04/01/1972
2.5
07/01/1972
10/01/1972
4.0
3.2
01/01/19
73
0.7
3.1
04/01/1973
0.8
07/01/1973
0.4
2.2
10/01/1973
1.1
01/01/19
74
-1.6
04/01/1974
–
0.9
07/01/1974
0.1
10/01/1974
-0.1
01/01/19
75
–
0.2
2.7
04/01/1975
4.6
07/01/1975
-1.5
3.3
10/01/1975
2.8
01/01/19
76
04/01/1976
07/01/1976
2.6
10/01/1976
0.6
01/01/19
77
–
0.0
3.0
Y
OUTPUT
1.2 04/01/1977 2.3
1.5 07/01/1977 2.5
Statistics
1.9 10/01/1977 3.0
7
9
0.7 01/01/1978 2.3
3
06
1.0 04/01/1978
8
0.7 07/01/1978 2.2
07
0.8 10/01/1978 2.7
s
1
1.1 01/01/1979 2.4
04/01/1979 2.7
0.5 07/01/1979
0.4 10/01/1979 2.7 Regression 1
6706
3.7792670
3
7
7
01
0
0.3 01/01/1980 2.8
.2
7
28
1
-1.5 04/01/1980 0.1
.0
21
59
1.2 07/01/1980
2.0 10/01/1980
Standard Error
01/01/1981 3.0
0
4848
7
97
7721
8
1E-45
823207338
98482358
1.3823207338 1.6
8482358
04/01/1981
02318
5
633
0.0257234201
9444916
0.0186759719 0.2859444916
2.0 07/01/1981 2.0
0.2 10/01/1981 0.8
0.1 01/01/1982 1.9
0.6 04/01/1982 1.3
0.5 07/01/1982 2.4
0.5 10/01/1982 3.0 Observation
Y
0.9 01/01/1983 1.8 1
3
6043
4
957
4
027
0.7 04/01/1983 2.9 2
99477
9477
72
1
1.5 07/01/1983 3.1 3
2
5
2186
2.2 10/01/1983 2.3 4
43
306
2.0 01/01/1984 1.9 5
4
1.7 04/01/1984 2.4 6
635
07/01/1984 1.6 7
5
0.8 10/01/1984 2.0 8
827332
01/01/1985 2.9 9
720858
432
1.9 04/01/1985 1.8 10
-0.3 07/01/1985 2.7 11
1.2 10/01/1985 0.9 12
6936578
0055
1.2 01/01/1986 1.6 13
1.3 04/01/1986 1.0 14
6747
3
0.7 07/01/1986 2.3 15
8
0.2 10/01/1986 1.2 16
0.8 01/01/1987 1.1 17
4323
04/01/1987 2.4 18
1.8 07/01/1987 2.1 19
1.3 10/01/1987 1.1 20
6653
1.5 01/01/1988 2.6 21
509286
1.0 04/01/1988 1.8 22
8
1.0 07/01/1988 2.1 23
1.0 10/01/1988 2.2 24
19
1.2 01/01/1989 1.6 25
4895
-0.3 04/01/1989 1.8 26
35
6581765
0.7 07/01/1989 1.6 27
2605
0.8 10/01/1989 1.2 28
915
0.8 01/01/1990 2.3 29
0.944
0.6 04/01/1990 1.2 30
0.0 07/01/1990 1.7 31
10/01/1990 0.5 32
7831969
541
0.2 01/01/1991 0.1 33
5
0.7 04/01/1991 1.4 34
0.4 07/01/1991 1.2 35
0.9 10/01/1991 0.7 36
8
1
2.1 01/01/1992 2.5 37
1.0 04/01/1992 1.4 38
7482
0.4 07/01/1992 1.7 39
61
0.3 10/01/1992 1.9 40
0.6 01/01/1993 1.0 41
0.2 04/01/1993 1.6 42
79
2098
0.1 07/01/1993 1.5 43
3
0.7 10/01/1993 1.5 44
0.7 01/01/1994 1.5 45
7
1.1 04/01/1994 1.3 46
43
0.6 07/01/1994 1.5 47
2
1.4 10/01/1994 1.6 48
82028
1.0 01/01/1995 0.7 49
12
0.2 04/01/1995 1.5 50
0.9 07/01/1995 1.3 51
4356
42
0.6 10/01/1995 1.1 52
1.0 01/01/1996 1.5 53
89854
0510146
1.0 04/01/1996 1.8 54
0.8 07/01/1996 1.0 55
0.5 10/01/1996 1.5 56
1.0 01/01/1997 1.5 57
0.9 04/01/1997 0.7 58
1.2 07/01/1997 2.0 59
1.4 10/01/1997 1.5 60
2.1 01/01/1998 1.0 61
1.4 04/01/1998 1.9 62
1.0 07/01/1998 1.6 63
0.8 10/01/1998 1.7 64
0.9 01/01/1999 1.2 65
3816474
0.2 04/01/1999 2.0 66
0.7 07/01/1999 1.7 67
1.5 10/01/1999 2.1 68
2.0 01/01/2000 2.4 69
75795
1.0 04/01/2000 1.4 70
1.2 07/01/2000 1.6 71
0.3 10/01/2000 1.4 72
0.9 01/01/2001 1.1 73
-0.1 04/01/2001 0.7 74
2.4 07/01/2001 0.4 75
10/01/2001 1.6 76
029
2.4 01/01/2002 0.5 77
2002
0.5 04/01/2002 1.3 78
-0.1 07/01/2002 1.2 79
0.5 10/01/2002 1.0 80
0.3 01/01/2003 1.1 81
1.4 04/01/2003 1.2 82
204984
1.6 07/01/2003 2.1 83
0499855
0.4 10/01/2003 1.2 84
0.7 01/01/2004 1.7 85
1.0 04/01/2004 1.4 86
0.5 07/01/2004 1.5 87
1.2 10/01/2004 1.8 88
-1.0 01/01/2005 1.3 89
0.8 04/01/2005 1.8 90
0.5 07/01/2005 1.9 91
402972
0.8 10/01/2005 1.2 92
50
2.3 01/01/2006 1.6 93
0.1 04/01/2006 1.3 94
98
0.3 07/01/2006 1.3 95
1.3 10/01/2006 0.8 96
0.7 01/01/2007 1.5 97
0.2 04/01/2007 1.1 98
0.3 07/01/2007 1.0 99
0.1 10/01/2007 1.1 100
0.7 01/01/2008 0.6 101
2.1 04/01/2008 1.2 102
07/01/2008 0.3 103
0.6 10/01/2008
104
-0.2 01/01/2009 -0.9 105
0.7 04/01/2009 -0.0
72
-1.1 07/01/2009 1.2 107
-0.1 10/01/2009 0.7 108
0.1 01/01/2010 0.9 109
1.3 04/01/2010 0.9
0.5 07/01/2010 0.9 111
0.7 10/01/2010 1.6 112
1.2 01/01/2011 1.3 113
-0.2 04/01/2011 1.2 114
0.5 07/01/2011 1.0 115
0.1 10/01/2011 0.7 116
1.6 01/01/2012 1.2 117
0.8 04/01/2012 0.5 118
-0.1 07/01/2012 0.6
5197
2.6 10/01/2012 0.8 120
01/01/2013 1.0 121
57668
0.7 04/01/2013 0.5 122
0.5 07/01/2013 0.8
0.1 10/01/2013 1.2 124
1.0 01/01/2014 0.7 125
0.7 04/01/2014 1.5 126
0.7 07/01/2014 1.2 127
1.1 10/01/2014 0.9
1.0 01/01/2015 -0.0 129
0.7 04/01/2015 1.4 130
0.9 07/01/2015 1.1 131
902129
89
Scatterplot of quarterly percent change in personal consumption expenditures and real disposable income, 1970: 1-2015:3
y = 0.1523x + 1.5411
0.98004000000000002 1.1819 1.56236 -0.25494 2.00407 1.46071 0.53320999999999996 1.1640600000000001 0.46082000000000001 1.0217799999999999 1.91957 3.9695900000000002 0.70818000000000003 0.79747000000000001 0.43475999999999998 1.09981 -1.64547 -0.93647000000000002 9.7089999999999996E-2 -0.12762000000000001 -0.15845000000000001 4.6434199999999999 -1.4554800000000001 0.76702999999999999 1.1676599999999999 0.52109000000000005 0.73640000000000005 0.59635000000000005 -3.108E-2 1.24339 1.5327900000000001 1.93068 0.70972000000000002 0.98797000000000001 0.72026000000000001 0.78863000000000005 1.0609599999999999 -0.85953999999999997 0.47431000000000001 0.43254999999999999 0.34323999999999999 -1.45322 1.2203999999999999 1.9636100000000001 -0.26990999999999998 -2.3630000000000002E-2 2.0453299999999999 0.19791 0.12187000000000001 0.57713999999999999 0.53417999999999999 0.45039000000000001 0.85748999999999997 0.71089000000000002 1.50939 2.1542699999999999 2.0401799999999999 1.66679 1.3728400000000001 0.82262000000000002 -0.23866999999999999 1.9231799999999999 -0.33479999999999999 1.15018 1.2454000000000001 1.32813 0.70901999999999998 0.17818999999999999 0.82484999999999997 -0.97375999999999996 1.81996 1.3362799999999999 1.45916 1.0260800000000001 0.96445999999999998 0.96506000000000003 1.2328699999999999 -0.29286000000000001 0.68052999999999997 0.80506 0.83975 0.59907999999999995 3.8969999999999998E-2 -0.79474999999999996 0.2152 0.68967999999999996 0.36426999999999998 0.85463 2.1469299999999998 1.04488 0.43807000000000001 0.34121000000000001 0.56330000000000002 0.17494999999999999 6.0170000000000001E-2 0.65564 0.70091000000000003 1.05924 0.59565999999999997 1.3878200000000001 0.95467000000000002 0.22806999999999999 0.89354 0.57896000000000003 0.95572999999999997 0.95481000000000005 0.79820999999999998 0.52171000000000001 1.00359 0.85467000000000004 1.19055 1.43215 2.1311900000000001 1.39734 1.0185900000000001 0.81342999999999999 0.89571999999999996 0.24753 0.67071000000000003 1.47045 1.97092 1.03593 1.1696899999999999 0.3367 0.85338000000000003 -8.8139999999999996E-2 2.3642799999999999 -1.23671 2.4313099999999999 0.50793999999999995 -0.12926000000000001 0.48057 0.28928999999999999 1.44963 1.63853 0.40226000000000001 0.72909999999999997 0.98529 0.52783000000000002 1.248 -0.96252000000000004 0.79039000000000004 0.51263000000000003 0.82521999999999995 2.28356 0.1499 8 0.28528999999999999 1.30708 0.65676999999999996 0.19649 0.25807999999999998 8.3960000000000007E-2 0.72826000000000002 2.09944 -2.2956099999999999 0.64587000000000006 -0.19325000000000001 0.71238000000000001 -1.0963799999999999 -0.13020000000000001 9.1810000000000003E-2 1.29975 0.49802000000000002 0.69557000000000002 1.22495 -0.15645999999999999 0.53120000000000001 5.9880000000000003E-2 1.6344000000000001 0.76985000000000003 -5.0700000000000002E-2 2.6266699999999998 -4.2308300000000001 0.65871999999999997 0.54578000000000004 0.14088999999999999 0.97706999999999999 0.73426000000000002 0.66527000000000003 1.14388 0.96592999999999996 0.65210000000000001 0.94064999999999999 1.786 1.56497 1.8676999999999999 1.0236799999999999 2.8735599999999999 2.0729199999999999 1.7859700000000001 2.2923399999999998 2.3793099999999998 2.49966 2.4386999999999999 3.1913499999999999 3.05524 1.88771 2.1971500000000002 1.7547900000000001 2.07857 3.1886299999999999 3.12263 1.0303899999999999 2.72661 2.9075099999999998 3.3274300000000001 2.7534299999999998 3.1339800000000002 1.7621100000000001 2.5973999999999999 2.9105300000000001 2.9704600000000001 2.2671899999999998 2.4791400000000001 2.9619300000000002 2.2516799999999999 4.2347900000000003 2.1832799999999999 2.71055 2.3966599999999998 2.6627200000000002 3.4902299999999999 2.6918299999999999 2.8321800000000001 0.14063999999999999 3.4408099999999999 3.8298399999999999 3.0129700000000001 1.65018 2.0448499999999998 0.76483999999999996 1.9330000000000001 1.3254600000000001 2.3565700000000001 2.9532799999999999 1.8457399999999999 2.9170099999999999 3.0960299999999998 2.2544400000000002 1.9396599999999999 2.4104299999999999 1.5516700000000001 1.95261 2.91954 1.7890200000000001 2.7311200000000002 0.94765999999999995 1.5693900000000001 0.99834000000000001 2.32972 1.2424500000000001 1.0855999999999999 2.3513299999999999 2.10832 1.0882400000000001 2.5697700000000001 1.8467199999999999 2.09429 2.1578900000000001 1.5907500000000001 1.8082800000000001 1.5688500000000001 1.2301800000000001 2.2996599999999998 1.2172099999999999 1.66307 0.5435600000 0000004 0.14932000000000001 1.3752500000000001 1.16642 0.68676999999999999 2.5042900000000001 1.3527 1.7252099999999999 1.90324 0.97775999999999996 1.5794900000000001 1.54366 1.46471 1.50481 1.33813 1.4926999999999999 1.5524500000000001 0.74682000000000004 1.4661900000000001 1.3219000000000001 1.14331 1.49471 1.7540500000000001 1.03162 1.4683999999999999 1.4992300000000001 0.70372000000000001 1.9726699999999999 1.50085 1.02504 1.9474800000000001 1.6217699999999999 1.72692 1.2121 2.0231699999999999 1.6664000000000001 2.0716700000000001 2.3702000000000001 1.4241200000000001 1.6015299999999999 1.44919 1.0944100000000001 0.73643000000000003 0.44257999999999997 1.5935999999999999 0.48221999999999998 1.28389 1.20634 0.99689000000000005 1.1495599999999999 1.1997100000000001 2.0951 1.18283 1.74342 1.35697 1.5427999999999999 1.82372 1.2854000000000001 1.7589900000000001 1.88104 1.16337 1.5892999999999999 1.3071600000000001 1.3032600000000001 0.84699999999999998 1.4608000000000001 1.1374299999999999 1.0133099999999999 1.1307 0.64985000000000004 1.21712 0.28824 -2.6202700000000001 -0.90673000000000004 -5.1200000000000004E-3 1.2395499999999999 0.67032000000000003 0.87777000000000005 0.92786999999999997 0.94399999999999995 1.56155 1.2537 1.2153799999999999 0.96701000000000004 0.68344000000000005 1.1 849000000000001 0.47643999999999997 0.59226999999999996 0.81906999999999996 0.96289000000000002 0.45245999999999997 0.83813000000000004 1.21916 0.72165000000000001 1.4836400000000001 1.15212 0.93981999999999999 -4.9750000000000003E-2 1.43421 1.0688299999999999
% change in Income
% change in Consumption
X Variable 1 Residual Plot
0.98004000000000002 1.1819 1.56236 -0.25494 2.00407 1.46071 0.53320999999999996 1.1640600000000001 0.46082000000000001 1.0217799999999999 1.91957 3.9695900000000002 0.70818000000000003 0.79747000000000001 0.43475999999999998 1.09981 -1.64547 -0.93647000000000002 9.7089999999999996E-2 -0.1276200000 0000001 -0.15845000000000001 4.6434199999999999 -1.4554800000000001 0.76702999999999999 1.1676599999999999 0.52109000000000005 0.73640000000000005 0.59635000000000005 -3.108E-2 1.24339 1.5327900000000001 1.93068 0.70972000000000002 0.98797000000000001 0.72026000000000001 0.78863000000000005 1.0609599999999999 -0.85953999999999997 0.47431000000000001 0.43254999999999999 0.34323999999999999 -1.45322 1.2203999999999999 1.9636100000000001 -0.26990999999999998 -2.3630000000000002E-2 2.0453299999999999 0.19791 0.12187000000000001 0.57713999999999999 0.53417999999999999 0.45039000000000001 0.85748999999999997 0.71089000000000002 1.50939 2.1542699999999999 2.0401799999999999 1.66679 1.3728400000000001 0.82262000000000002 -0.2386699999 9999999 1.9231799999999999 -0.33479999999999999 1.15018 1.2454000000000001 1.32813 0.70901999999999998 0.17818999999999999 0.82484999999999997 -0.97375999999999996 1.81996 1.3362799999999999 1.45916 1.0260800000000001 0.96445999999999998 0.96506000000000003 1.2328699999999999 -0.29286000000000001 0.68052999999999997 0.80506 0.83975 0.59907999999999995 3.8969999999999998E-2 -0.79474999999999996 0.2152 0.68967999999999996 0.36426999999999998 0.85463 2.1469299999999998 1.04488 0.43807000000000001 0.34121000000000001 0.56330000000000002 0.17494999999999999 6.0170000000000001E-2 0.65564 0.70091000000000003 1.05924 0.59565999999999997 1.3878200000000001 0.95467000000000002 0.22806999999999999 0.893 54 0.57896000000000003 0.95572999999999997 0.95481000000000005 0.79820999999999998 0.52171000000000001 1.00359 0.85467000000000004 1.19055 1.43215 2.1311900000000001 1.39734 1.0185900000000001 0.81342999999999999 0.89571999999999996 0.24753 0.67071000000000003 1.47045 1.97092 1.03593 1.1696899999999999 0.3367 0.85338000000000003 -8.8139999999999996E-2 2.3642799999999999 -1.23671 2.4313099999999999 0.50793999999999995 -0.12926000000000001 0.48057 0.28928999999999999 1.44963 1.63853 0.40226000000000001 0.72909999999999997 0.98529 0.52783000000000002 1.248 -0.96252000000000004 0.79039000000000004 0.51263000000000003 0.82521999999999995 2.28356 0.14998 0.28528999999999999 1.30708 0.65676999999999996 0.19649 0.25807999999999998 8.3960000000000007E-2 0.72826000000000002 2.09944 -2.2956099999999999 0.64587000000000006 -0.19325000000000001 0.71238000000000001 -1.0963799999999999 -0.13020000000000001 9.1810000000000003E-2 1.29975 0.49802000000000002 0.69557000000000002 1.22495 -0.15645999999999999 0.53120000000000001 5.9880000000000003E-2 1.6344000000000001 0.76985000000000003 -5.0700000000000002E-2 2.6266699999999998 -4.2308300000000001 0.65871999999999997 0.54578000000000004 0.14088999999999999 0.97706999999999999 0.73426000000000002 0.66527000000000003 1.14388 0.96592999999999996 0.65210000000000001 0.94064999999999999 9.5645395655630239E-2 -0.15612994773091193 8.8652101487141088E-2 -0.47857451430418441 1.0272351490088414 0.30935443654729156 0.16367217652062904 0.57395726680399295 0.76803791419897904 0.80294796658125067 0.60524536359401337 1.0456563422461529 1.4062924552665752 0.22516267467119055 0.5898471188390928 4.6193199195677215E-2 0.78810743228894209 1.7901794779589191 1.5667577148032941 -0.49125665301405519 1.2096590714316353 0.65918513876773366 2.0080300113535952 1.0955189981264879 1.4150489499695955 0.14165817652976842 0.94415426052582307 1.2786153084862177 1.4341093172101758 0.53672449611710893 0.70459591504079255 1.1267831969189692 0.60249789750963822 2.5432275755176375 0.53249254766670684 1.0493490971201009 0.69398045170022038 1.2525522518283008 1.876903249172305 1.0848637244513202 1.2388165512513405 -1.1791042097702213 1.7138461083456664 1.9896776209865463 1.5129955698655204 0.1126946059834355 0.19224082884571492 -0.80638820276448153 0.37335346725985552 -0.30352881196134263 0.7341244355958052 1.3435965099164151 0.17405101455992411 1.267649694538459 1.3250499744643782 0.38523815219590896 8.7835226539367373E-2 0.61547634398264961 -0.198512063386447 0.28623207234199444 1.4148073982248011 -4.4984476342702084E-2 1.2410289808055417 -0.76860866717893961 -0.16138164744876282 -0.74503227292368934 0.68064451467188247 -0.32577464499383546 -0.58111757947486886 0.95855912650189046 0.29003698578133874 -0.6563736013126733 0.80644051740654654 0.14935303258460864 0.40630838906671873 0.46981700292765249 -0.13811320024459484 0.31180108968480669 -7.5886166824785439E-2 -0.43352335998799818 0.63067299807165123 -0.4151204984465342 0.11604998547418388 -0.87647592808854302 -1.424541646671909 -0.2708798054455468 -0.4301465329229337 -0.98448337817719322 0.63620610929715338 -0.34753039977280231 0.11740297197191008 0.31018574102184826 -0.6491208383535465 1.1758840157122696E-2 -6.5889914394923199E-3 -0.17623516515585158 -0.14303024934840458 -0.3642875747011225 -0.13910959745385609 -0.2000136706584692 -0.93967049376418244 -0.10963187935488139 -0.35527976929564331 -0.48595601658317711 -0.19194194260986652 6.7538182803368763E-2 -0.63104003490032445 -0.15214625581393348 -0.19471151030272238 -0.96753947058646428 0.25025256876421542 -0.25836558323315195 -0.84064652765467396 0.19356633593501194 -7.4456163779380136E-2 6.1941803372026705E-2 -0.4654118056009175 5 0.44438416353473453 2.3159519651266391E-2 0.30662093488978215 0.52892423319225523 -0.27474722319839651 -0.11771023980091266 -0.14317733983283687 -0.57665299038747153 -0.79122986096461834 -1.4586085195796175 0.24087910194770057 -1.4291778744156423 -0.33455894392236152 -0.31505686423394064 -0.61739021287861995 -0.43558631174428064 -0.56216796608461705 0.3044506311326729 -0.4195227986281489 9.1286125217796554E-2 -0.33418423306119993 -7.8678394432409871E-2 9.2552345948616388E-2 -0.10908284050328509 9.7521031112173029E-2 0.26187672109060345 -0.50340393426062624 -0.29959403767056325 -0.25676797335540114 -0.28127707081717168 -0.89316614254477966 -0.18031727571775957 -0.43358192223535807 -0.56708270941051464 -0.42317245185347163 -1.0021559341875106 -0.64373067779574833 -0.90319959362344004 -4.2597270941913887 -2.4183805325025185 -1.6547072477068889 -0.13454459287759146 -0.85093369261606999 -0.6772980871729225 -0.81117970854585297 -0.67293802642313194 -8.5476912710714448E-2 -0.47395690320891948 -0.30187402592960133 -0.65498167991349876 -0.86676482147227696 -0.60512032761008716 -1.1819005167271237 -0.94109235604235619 -1.1220832012956325 6.6204213116399901E-2 -1.1889542806697251 -0.78608236309281021 -0.34338347334854658 -0.96825224295599155 -0.16927979557817352 -0.49029191268786576 -0.77548911271874343 -1.7379555069739936 -0.20619598693536023 -0.61552510431466656 X Variable 1
Residuals
X Variable 1 Line Fit Plot
Y 0.98004000000000002 1.1819 1.56236 -0.25494 2.00407 1.46071 0.53320999999999996 1.1640600000000001 0.46082000000000001 1.0217799999999999 1.91957 3.9695900000000002 0.70818000000000003 0.79747000000000001 0.43475999999999998 1.09981 -1.64547 -0.93647000000000002 9.7089999999999996E-2 -0.12762000000000001 -0.15845000000000001 4.6434199999999999 -1.4554800000000001 0.76702999999999999 1.1676599999999999 0.52109000000000005 0.73640000000000005 0.59635000000000005 -3.108E-2 1.24339 1.5327900000000001 1.93068 0.70972000000000002 0.98797000000000001 0.72026000000000001 0.78863000000000005 1.0609599999999999 -0.85953999999999997 0.47431000000000001 0.43254999999999999 0.34323999999999999 -1.45322 1.2203999999999999 1.9636100000000001 -0.26990999999999998 -2.3630000000000002E-2 2.0453299999999999 0.19791 0.12187000000000001 0.57713999999999999 0.53417999999999999 0.45039000000000001 0.85748999999999997 0.71089000000000002 1.50939 2.1542699999999999 2.0401799999999999 1.66679 1.3728400000000001 0.82262000000000002 -0.23866999999999999 1.9231799999999999 -0.33479999999999999 1.15018 1.2454000000000001 1.32813 0.70901999999999998 0.17818999999999999 0.82484999999999997 -0.97375999999999996 1.81996 1.3362799999999999 1.45916 1.0260800000000001 0.96445999999999998 0.96506000000000003 1.2328699999999999 -0.29286000000000001 0.68052999999999997 0.80506 0.83975 0.59907999999999995 3.8969999999999998E-2 -0.79474999999999996 0.2152 0.68967999999999996 0.36426999999999998 0.85463 2.1469299999999998 1.04488 0.43807000000000001 0.34121000000000001 0.56330000000000002 0.17494999999999999 6.0170000000000001E-2 0.65564 0.70091000000000003 1.05924 0.59565999999999997 1.3878200000000001 0.95467000000000002 0.22806999999999999 0.89354 0.57896000000000003 0.95572999999999997 0.95481000000000005 0.79820999999999998 0.52171000000000001 1.00359 0.85467000000000004 1.19055 1.43215 2.1311900000000001 1.39734 1.0185900000000001 0.81342999999999999 0.89571999999999996 0.24753 0.67071000000000003 1.47045 1.97092 1.03593 1.1696899999999999 0.3367 0.85338000000000003 -8.8139999999999996E-2 2.3642799999999999 -1.23671 2.4313099999999999 0.50793999999999995 -0.12926000000000001 0.48057 0.28928999999999999 1.44963 1.63853 0.40226000000000001 0.72909999999999997 0.98529 0.52783000000000002 1.248 -0.96252000000000004 0.79039000000000004 0.51263000000000003 0.82521999999999995 2.28356 0.14998 0.28528999999999999 1.30708 0.65676999999999996 0.19649 0.25807999999999998 8.3960000000000007E-2 0.72826000000000002 2.09944 -2.2956099999999999 0.64587000000000006 -0.19325000000000001 0.71238000000000001 -1.0963799999999999 -0.13020000000000001 9.1810000000000003E-2 1.29975 0.49802000000000002 0.69557000000000002 1.22495 -0.15645999999999999 0.53120000000000001 5.9880000000000003E-2 1.6344000000000001 0.76985000000000003 -5.0700000000000002E-2 2.6266699999999998 -4.2308300000000001 0.65871999999999997 0.54578000000000004 0.14088999999999999 0.97706999999999999 0.73426000000000002 0.66527000000000003 1.14388 0.96592999999999996 0.65210000000000001 0.94064999999999999 1.786 1.56497 1.8676999999999999 1.0236799999999999 2.8735599999999999 2.0729199999999999 1.7859700000000001 2.2923399999999998 2.3793099999999998 2.49966 2.4386999999999999 3.1913499999999999 3.05524 1.88771 2.1971500000000002 1.7547900000000001 2.07857 3.1886299999999999 3.12263 1.0303899999999999 2.72661 2.9075099999999998 3.3274300000000001 2.7534299999999998 3.1339800000000002 1.7621100000000001 2.5973999999999999 2.9105300000000001 2.9704600000000001 2.2671899999999998 2.4791400000000001 2.9619300000000002 2.2516799999999999 4.2347900000000003 2.1832799999999999 2.71055 2.3966599999999998 2.6627200000000002 3.4902299999999999 2.6918299999999999 2.8321800000000001 0.14063999999999999 3.4408099999999999 3.8298399999999999 3.0129700000000001 1.65018 2.0448499999999998 0.76483999999999996 1.9330000000000001 1.3254600000000001 2.3565700000000001 2.9532799999999999 1.8457399999999999 2.9170099999999999 3.0960299999999998 2.2544400000000002 1.9396599999999999 2.4104299999999999 1.5516700000000001 1.95261 2.91954 1.7890200000000001 2.7311200000000002 0.94765999999999995 1.5693900000000001 0.99834000000000001 2.32972 1.2424500000000001 1.0855999999999999 2.3513299999999999 2.10832 1.0882400000000001 2.5697700000000001 1.8467199999999999 2.09429 2.1578900000000001 1.5907500000000001 1.8082800000000001 1.5688500000000001 1.2301800000000001 2.2996599999999998 1.2172099999999999 1.66307 0.54356000000000004 0.14932000000000001 1.3752500000000001 1.16642 0.68676999999999999 2.5042900000000001 1.3527 1.7252099999999999 1.90324 0.97775999999999996 1.5794900000000001 1.54366 1.46471 1.50481 1.33813 1.4926999999999999 1.5524500000000001 0.74682000000000004 1.4661900000000001 1.3219000000000001 1.14331 1.49471 1.7540500000000001 1.03162 1.4683999999999999 1.4992300000000001 0.70372000000000001 1.9726699999999999 1.50085 1.02504 1.9474800000000001 1.6217699999999999 1.72692 1.2121 2.0231699999999999 1.6664000000000001 2.0716700000000001 2.3702000000000001 1.4241200000000001 1.6015299999999999 1.44919 1.0944100000000001 0.73643000000000003 0.44257999999999997 1.5935999999999999 0.48221999999999998 1.28389 1.20634 0.99689000000000005 1.1495599999999999 1.1997100000000001 2.0951 1.18283 1.74342 1.35697 1.5427999999999999 1.82372 1.2854000000000001 1.7589900000000001 1.88104 1.16337 1.5892999999999999 1.3071600000000001 1.3032600000000001 0.84699999999999998 1.4608000000000001 1.1374299999999999 1.0133099999999999 1.1307 0.64985000000000004 1.21712 0.28824 -2.6202700000000001 -0.90673000000000004 -5.1200000000000004E-3 1.2395499999999999 0.67032000000000003 0.87777000000000005 0.92786999999999997 0.94399999999999995 1.56155 1.2537 1.2153799999999999 0.96701000000000004 0.6 8344000000000005 1.1849000000000001 0.47643999999999997 0.59226999999999996 0.81906999999999996 0.96289000000000002 0.45245999999999997 0.83813000000000004 1.21916 0.72165000000000001 1.4836400000000001 1.15212 0.93981999999999999 -4.9750000000000003E-2 1.43421 1.0688299999999999 Predicted Y 0.98004000000000002 1.1819 1.56236 -0.25494 2.00407 1.46071 0.53320999999999996 1.1640600000000001 0.46082000000000001 1.0217799999999999 1.91957 3.9695900000000002 0.70818000000000003 0.79747000000000001 0.434759999999999 98 1.09981 -1.64547 -0.93647000000000002 9.7089999999999996E-2 -0.12762000000000001 -0.15845000000000001 4.6434199999999999 -1.4554800000000001 0.76702999999999999 1.1676599999999999 0.52109000000000005 0.73640000000000005 0.59635000000000005 -3.108E-2 1.24339 1.5327900000000001 1.93068 0.70972000000000002 0.98797000000000001 0.72026000000000001 0.78863000000000005 1.0609599999999999 -0.85953999999999997 0.47431000000000001 0.43254999999999999 0.34323999999999999 -1.45322 1.2203999999999999 1.9636100000000001 -0.26990999999999998 -2.3630000000000002E-2 2.0453299999999999 0.19791 0.12187000000000001 0.57713999999999999 0.53417999999999999 0.45039000000000001 0.85748999999999997 0.71089000000000002 1.50939 2.1542699999999999 2.0401799999999999 1.66679 1.3728400000000001 0.82262000000000002 -0.23866999999999999 1.9231799999999999 -0.33479999999999999 1.15018 1.2454000000000001 1.32813 0.70901999999999998 0.17818999999999999 0.82484999999999997 -0.97375999999999996 1.81996 1.3362799999999999 1.45916 1.0260800000000001 0.96445999999999998 0.96506000000000003 1.2328699999999999 -0.29286000000000001 0.68052999999999997 0.80506 0.83975 0.59907999999999995 3.8969999999999998E-2 -0.79474999999999996 0.2152 0.68967999999999996 0.36426999999999998 0.85463 2.1469299999999998 1.04488 0.43807000000000001 0.34121000000000001 0.56330000000000002 0.17494999999999999 6.0170000000000001E-2 0.65564 0.70091000000000003 1.05924 0.59565999999999997 1.3878200000000001 0.95467000000000002 0.22806999999999999 0.89354 0.57896000000000003 0.95572999999999997 0.95481000000000005 0.79820999999999998 0.52171000000000001 1.00359 0.85467000000000004 1.19055 1.43215 2.1311900000000001 1.39734 1.0185900000000001 0.81342999999999999 0.89571999999999996 0.24753 0.67071000000000003 1.47045 1.97092 1.03593 1.1696899999999999 0.3367 0.85338000000000003 -8.8139999999999996E-2 2.3642799999999999 -1.23671 2.4313099999999999 0.50793999999999995 -0.12926000000000001 0.48057 0.28928999999999999 1.44963 1.63853 0.40226000000000001 0.72909999999999997 0.98529 0.52783000000000002 1.248 -0.96252000000000004 0.79039000000000004 0.51263000000000003 0.82521999999999995 2.28356 0.14998 0.28528999999999999 1.30708 0.65676999999999996 0.19649 0.25807999999999998 8.3960000000000007E-2 0.72826000000000002 2.09944 -2.2956099999999999 0.64587000000000006 -0.19325000000000001 0.71238000000000001 -1.0963799999999999 -0.13020000000000001 9.1810000000000003E-2 1.29975 0.49802000000000002 0.69557000000000002 1.22495 -0.15645999999999999 0.53120000000000001 5.9880000000000003E-2 1.6344000000000001 0.76985000000000003 -5.0700000000000002E-2 2.6266699999999998 -4.2308300000000001 0.65871999999999997 0.54578000000000004 0.14088999999999999 0.97706999999999999 0.73426000000000002 0.66527000000000003 1.14388 0.96592 999999999996 0.65210000000000001 0.94064999999999999 1.6903546043443698 1.7210999477309119 1.7790478985128588 1.5022545143041843 1.8463248509911585 1.7635655634527083 1.622297823479371 1.7183827331960069 1.6112720858010208 1.6967120334187493 1.8334546364059865 2.145693657753847 1.6489475447334248 1.6625473253288094 1.6073028811609074 1.7085968008043229 1.2904625677110579 1.3984505220410808 1.555872285196706 1.5216466530140551 1.5169509285683647 2.2483248612322662 1.319399988646405 1.6579110018735119 1.7189310500304047 1.6204518234702316 1.6532457394741769 1.6319146915137823 1.5363506827898243 1.7304655038828909 1.7745440849592076 1.835146803081031 1.6491821024903617 1.6915624244823628 1.650787452333293 1.6612009028798991 1.7026795482997794 1.4101677481716994 1.6133267508276949 1.6069662755486798 1.5933634487486596 1.3197442097702214 1.7269638916543335 1.8401623790134536 1.4999744301344797 1.5374853940165645 1.8526091711542849 1.5712282027644815 1.5596465327401445 1.6289888119613427 1.6224455644041949 1.6096834900835848 1.6716889854400758 1.6493603054615409 1.7709800255356216 1.8692018478040913 1.8518247734606326 1.7949536560173502 1.7501820633864471 1.6663779276580055 1.504732601775199 1.8340044763427021 1.4900910191944585 1.7162686671789396 1.7307716474487629 1.7433722729236893 1.6490754853281175 1.5682246449938355 1.6667175794748688 1.3927708734981095 1.8182830142186612 1.7446136013126734 1.7633294825934536 1.6973669674153913 1.6879816109332813 1.6880729970723476 1.7288632002445949 1.4964789103151934 1.6447361668247855 1.6637033599879982 1.6689870019283486 1.6323304984465341 1.5470200145258162 1.4200359280885431 1.5738616466719091 1.6461298054455469 1.5965665329229337 1.6712533781771932 1.8680838907028467 1.7002303997728023 1.6078070280280898 1.5930542589781518 1.6268808383535465 1.5677311598428774 1.5502489914394924 1.6409451651558515 1.6478402493484046 1.7024175747011225 1.631809597453856 1.7524636706584693 1.6864904937641825 1.5758218793548815 1.6771797692956434 1.6292660165831772 1.6866519426098665 1.6865118171966313 1.6626600349003244 1.6205462558139334 1.6939415103027224 1.6712594705864643 1.7224174312357845 1.759215583233152 1.8656865276546739 1.7539136640649882 1.6962261637793801 1.6649781966279733 1.6775118056009175 1.5787858364652654 1.6432404803487337 1.765049065110218 1.8412757668077449 1.6988672231983966 1.7192402398009126 1.5923673398328368 1.6710629903874716 1.5276598609646184 1.9011885195796174 1.3527208980522993 1.9113978744156421 1.6184489439223615 1.5213968642339406 1.61428021287862 1.5851463117442806 1.7618779660846171 1.7906493688673271 1.6023527986281489 1.6521338747822034 1.6911542330611999 1.6214783944324098 1.7311676540513836 1.3944828405032852 1.661468968887827 1.6191632789093966 1.6667739342606263 1.8888940376705632 1.5639279733554012 1.5845370708171718 1.7401661425447796 1.6411172757177597 1.571011922235358 1.5803927094105146 1.5538724518534717 1.6520059341875106 1.8608506777957483 1.1914395936234401 1.6394570941913884 1.5116505325025187 1.6495872477068889 1.3740945928775914 1.52125369261607 1.5550680871729226 1.7390497085458529 1.6169380264231319 1.6470269127107144 1.7276569032089195 1.5172540259296012 1.6219916799134988 1.550204821472277 1.7900203276100872 1.6583405167271237 1.5333623560423562 1.9411532012956325 0.89668578688360012 1.6414142806697252 1.6242123630928103 1.5625434733485466 1.6899022429559916 1.6529197955781736 1.6424119126878658 1.7153091127187434 1.6882055069739936 1.6404059869353602 1.6843551043146665 X Variable 1
Y
Normal Probability Plot
0.27322404371584702 0.81967213114754101 1.3661202185792352 1.9125683060109291 2.459016393442623 3.0054644808743172 3.5519125683060109 4.0983606557377055 4.6448087431693992 5.1912568306010929 5.7377049180327875 6.2841530054644812 6.8306010928961749 7.3770491803278695 7.9234972677595632 8.4699453551912587 9.0163934426229524 9.5628415300546461 10.10928961748634 10.655737704918035 11.202185792349729 11.748633879781423 12.295081967213116 12.84153005464481 13.387978142076504 13.934426229508199 14.480874316939893 15.027322404371587 15.57377049180328 16.120218579234972 16.666666666666668 17.21311475409836 17.759562841530055 18.306010928961751 18.852459016393443 19.398907103825138 19.94535519125683 20.491803278688526 21.038251366120221 21.584699453551913 22.131147540983608 22.6775956284153 23.224043715846996 23.770491803278691 24.316939890710383 24.863387978142079 25.409836065573771 25.956284153005466 26.502732240437158 27.049180327868854 27.595628415300549 28.142076502732241 28.688524590163937 29.234972677595628 29.781420765027324 30.327868852459019 30.874316939890711 31.420765027322407 31.967213114754099 32.513661202185801 33.060109289617493 33.606557377049185 34.153005464480877 34.699453551912576 35.245901639344268 35.79234972677596 36.338797814207659 36.885245901639351 37.431693989071043 37.978142076502735 38.524590163934434 39.071038251366126 39.617486338797818 40.163934426229517 40.710382513661209 41.256830601092901 41.8032786885246 42.349726775956292 42.896174863387984 43.442622950819676 43.989071038251375 44.535519125683066 45.081967213114758 45.628415300546457 46.174863387978149 46.721311475409841 47.26775956284154 47.814207650273232 48.360655737704924 48.907103825136616 49.453551912568315 50.000000000000007 50.546448087431699 51.092896174863398 51.63934426229509 52.185792349726782 52.732240437158474 53.278688524590173 53.8251366120 21865 54.371584699453557 54.918032786885256 55.464480874316948 56.01092896174864 56.557377049180339 57.103825136612031 57.650273224043723 58.196721311475414 58.743169398907114 59.289617486338805 59.836065573770497 60.382513661202196 60.928961748633888 61.47540983606558 62.021857923497279 62.568306010928971 63.114754098360663 63.661202185792355 64.207650273224047 64.754098360655746 65.300546448087431 65.84699453551913 66.393442622950815 66.939890710382514 67.486338797814213 68.032786885245898 68.579234972677597 69.125683060109296 69.672131147540981 70.21857923497268 70.765027322404379 71.311475409836063 71.857923497267763 72.404371584699462 72.950819672131146 73.497267759562845 74.043715846994544 74.590163934426229 75.136612021857928 75.683060109289613 76.229508196721312 76.775956284153011 77.322404371584696 77.868852459016395 78.415300546448094 78.961748633879779 79.508196721311478 80.054644808743177 80.601092896174862 81.147540983606561 81.69398907103826 82.240437158469945 82.786885245901644 83.333333333333343 83.879781420765028 84.426229508196727 84.972677595628426 85.519125683060111 86.06557377049181 86.612021857923494 87.158469945355193 87.704918032786892 88.251366120218577 88.797814207650276 89.344262295081975 89.89071038251366 90.437158469945359 90.983606557377058 91.530054644808743 92.076502732240442 92.622950819672141 93.169398907103826 93.715846994535525 94.262295081967224 94.808743169398909 95.355191256830608 95.901639344262293 96.448087431693992 96.99453 5519125691 97.540983606557376 98.087431693989075 98.633879781420774 99.180327868852459 99.726775956284158 -2.6202700000000001 -0.90673000000000004 -4.9750000000000003E-2 -5.1200000000000004E-3 0.14063999999999999 0.14932000000000001 0.28824 0.44257999999999997 0.45245999999999997 0.47643999999999997 0.48221999999999998 0.54356000000000004 0.59226999999999996 0.64985000000000004 0.67032000000000003 0.68344000000000005 0.68676999999999999 0.70372000000000001 0.72165000000000001 0.73643000000000003 0.74682000000000004 0.76483999999999996 0.81906999999999996 0.83813000000000004 0.84699999999999998 0.87777000000000005 0.92786999999999997 0.93981999999999999 0.94399999999999995 0.94765999999999995 0.96289000000000002 0.96701000000000004 0.97775999999999996 0.99689000000000005 0.99834000000000001 1.0133099999999999 1.0236799999999999 1.02504 1.0303899999999999 1.03162 1.0688299999999999 1.0855999999999999 1.0882400000000001 1.0944100000000001 1.1307 1.1374299999999999 1.14331 1.1495599999999999 1.15212 1.16337 1.16642 1.18283 1.1849000000000001 1.1997100000000001 1.20634 1.2121 1.2153799999999999 1.21712 1.2172099999999999 1.21916 1.2301800000000001 1.2395499999999999 1.2424500000000001 1.2537 1.28389 1.2854000000000001 1.3032600000000001 1.3071600000000001 1.3219000000000001 1.3254600000000001 1.33813 1.3527 1.35697 1.3752500000000001 1.4241200000000001 1.43421 1.44919 1.4608000000000001 1.46471 1.4661900000000001 1.4683999999999999 1.4836400000000001 1.4926999999999999 1.49471 1.4992300000000001 1.50085 1.50481 1.5427999999999999 1.54366 1.5516700000000001 1.5524500000000001 1.56155 1.56497 1.5688500000000001 1.5693900000000001 1.5794900000000001 1.5892999999999999 1.5907500000000001 1.5935999999999999 1.6015299999999999 1.6217699999999999 1.65018 1.66307 1.6664000000000001 1.7252099999999999 1.72692 1.74342 1.7540500000000001 1.7547900000000001 1.7589900000000001 1.7621100000000001 1.7859700000000001 1.786 1.7890200000000001 1.8082800000000001 1.82372 1.8457399999999999 1.8467199999999999 1.8676999999999999 1.88104 1.88771 1.90324 1.9330000000000001 1.9396599999999999 1.9474800000000001 1.95261 1.9726699999999999 2.0231699999999999 2.0448499999999998 2.0716700000000001 2.0729199999999999 2.07857 2.09429 2.0951 2.10832 2.1578900000000001 2.1832799999999999 2.1971500000000002 2.2516799999999999 2.2544400000000002 2.2671899999999998 2.2923399999999998 2.2996599999999998 2.32972 2.3513299999999999 2.3565700000000001 2.3702000000000001 2.3793099999999998 2.3966599999999998 2.4104299999999999 2.4386999999999999 2.4791400000000001 2.49966 2.5042900000000001 2.5697700000000001 2.5973999999999999 2.6627200000000002 2.6918299999999999 2.71055 2.72661 2.7311200000000002 2.7534299999999998 2.8321800000000001 2.8735599999999999 2.9075099999999998 2.9105300000000001 2.9170099999999999 2.91954 2.9532799999999999 2.9619300000000002 2.9704600000000001 3.0129700000000001 3.05524 3.0960299999999998 3.12263 3.1339800000000002 3.1886299999999999 3.1913499999999999 3.3274300000000001 3.4408099999999999 3.4902299999999999 3.8298399999999999 4.2347900000000003
Sample Percentile
Y
https://research.stlouisfed.org/fred2/series/DSPIC96
https://research.stlouisfed.org/fred2/series/PCE