FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fred.stlouisfed.org/help-faq
Economic Research Division
Federal Reserve Bank of St. Louis
CPIAUCSL
Consumer Price Index for All Urban Consumers: All Items, Index 1982-1984=100, Monthly, Seasona
Frequency: Monthly
observation_date
CPIAUCSL
1947-01-01
1947-02-01
1947-03-01
1947-04-01
1947-05-01
1947-06-01
1947-07-01
1947-08-01
1947-09-01
1947-10-01
1947-11-01
1947-12-01
1948-01-01
1948-02-01
1948-03-01
1948-04-01
1948-05-01
1948-06-01
1948-07-01
1948-08-01
1948-09-01
1948-10-01
1948-11-01
1948-12-01
1949-01-01
1949-02-01
1949-03-01
1949-04-01
1949-05-01
1949-06-01
1949-07-01
1949-08-01
1949-09-01
1949-10-01
1949-11-01
1949-12-01
1950-01-01
1950-02-01
1950-03-01
1950-04-01
1950-05-01
21.480
21.620
22.000
22.000
21.950
22.080
22.230
22.400
22.840
22.910
23.060
23.410
23.680
23.670
23.500
23.820
24.010
24.150
24.400
24.430
24.360
24.310
24.160
24.050
24.010
23.910
23.910
23.920
23.910
23.920
23.700
23.700
23.750
23.670
23.700
23.610
23.510
23.610
23.640
23.650
23.770
1950-06-01
1950-07-01
1950-08-01
1950-09-01
1950-10-01
1950-11-01
1950-12-01
1951-01-01
1951-02-01
1951-03-01
1951-04-01
1951-05-01
1951-06-01
1951-07-01
1951-08-01
1951-09-01
1951-10-01
1951-11-01
1951-12-01
1952-01-01
1952-02-01
1952-03-01
1952-04-01
1952-05-01
1952-06-01
1952-07-01
1952-08-01
1952-09-01
1952-10-01
1952-11-01
1952-12-01
1953-01-01
1953-02-01
1953-03-01
1953-04-01
1953-05-01
1953-06-01
1953-07-01
1953-08-01
1953-09-01
1953-10-01
1953-11-01
1953-12-01
1954-01-01
1954-02-01
1954-03-01
1954-04-01
1954-05-01
1954-06-01
1954-07-01
1954-08-01
1954-09-01
23.880
24.070
24.200
24.340
24.500
24.600
24.980
25.380
25.830
25.880
25.920
25.990
25.930
25.910
25.860
26.030
26.160
26.320
26.470
26.450
26.410
26.390
26.460
26.470
26.530
26.680
26.690
26.630
26.690
26.690
26.710
26.640
26.590
26.630
26.690
26.700
26.770
26.790
26.850
26.890
26.950
26.850
26.870
26.940
26.990
26.930
26.860
26.930
26.940
26.860
26.850
26.810
1954-10-01
1954-11-01
1954-12-01
1955-01-01
1955-02-01
1955-03-01
1955-04-01
1955-05-01
1955-06-01
1955-07-01
1955-08-01
1955-09-01
1955-10-01
1955-11-01
1955-12-01
1956-01-01
1956-02-01
1956-03-01
1956-04-01
1956-05-01
1956-06-01
1956-07-01
1956-08-01
1956-09-01
1956-10-01
1956-11-01
1956-12-01
1957-01-01
1957-02-01
1957-03-01
1957-04-01
1957-05-01
1957-06-01
1957-07-01
1957-08-01
1957-09-01
1957-10-01
1957-11-01
1957-12-01
1958-01-01
1958-02-01
1958-03-01
1958-04-01
1958-05-01
1958-06-01
1958-07-01
1958-08-01
1958-09-01
1958-10-01
1958-11-01
1958-12-01
1959-01-01
26.720
26.780
26.770
26.770
26.820
26.790
26.790
26.770
26.710
26.760
26.720
26.850
26.820
26.880
26.870
26.830
26.860
26.890
26.930
27.030
27.150
27.290
27.310
27.350
27.510
27.510
27.630
27.670
27.800
27.860
27.930
28.000
28.110
28.190
28.280
28.320
28.320
28.410
28.470
28.640
28.700
28.870
28.940
28.940
28.910
28.890
28.940
28.910
28.910
28.950
28.970
29.010
1959-02-01
1959-03-01
1959-04-01
1959-05-01
1959-06-01
1959-07-01
1959-08-01
1959-09-01
1959-10-01
1959-11-01
1959-12-01
1960-01-01
1960-02-01
1960-03-01
1960-04-01
1960-05-01
1960-06-01
1960-07-01
1960-08-01
1960-09-01
1960-10-01
1960-11-01
1960-12-01
1961-01-01
1961-02-01
1961-03-01
1961-04-01
1961-05-01
1961-06-01
1961-07-01
1961-08-01
1961-09-01
1961-10-01
1961-11-01
1961-12-01
1962-01-01
1962-02-01
1962-03-01
1962-04-01
1962-05-01
1962-06-01
1962-07-01
1962-08-01
1962-09-01
1962-10-01
1962-11-01
1962-12-01
1963-01-01
1963-02-01
1963-03-01
1963-04-01
1963-05-01
29.000
28.970
28.980
29.040
29.110
29.150
29.180
29.250
29.350
29.350
29.410
29.370
29.410
29.410
29.540
29.570
29.610
29.550
29.610
29.610
29.750
29.780
29.810
29.840
29.840
29.840
29.810
29.840
29.840
29.920
29.940
29.980
29.980
29.980
30.010
30.040
30.110
30.170
30.210
30.240
30.210
30.220
30.280
30.420
30.380
30.380
30.380
30.440
30.480
30.510
30.480
30.510
1963-06-01
1963-07-01
1963-08-01
1963-09-01
1963-10-01
1963-11-01
1963-12-01
1964-01-01
1964-02-01
1964-03-01
1964-04-01
1964-05-01
1964-06-01
1964-07-01
1964-08-01
1964-09-01
1964-10-01
1964-11-01
1964-12-01
1965-01-01
1965-02-01
1965-03-01
1965-04-01
1965-05-01
1965-06-01
1965-07-01
1965-08-01
1965-09-01
1965-10-01
1965-11-01
1965-12-01
1966-01-01
1966-02-01
1966-03-01
1966-04-01
1966-05-01
1966-06-01
1966-07-01
1966-08-01
1966-09-01
1966-10-01
1966-11-01
1966-12-01
1967-01-01
1967-02-01
1967-03-01
1967-04-01
1967-05-01
1967-06-01
1967-07-01
1967-08-01
1967-09-01
30.610
30.690
30.750
30.720
30.750
30.780
30.880
30.940
30.910
30.940
30.950
30.980
31.010
31.020
31.050
31.080
31.120
31.210
31.250
31.280
31.280
31.310
31.380
31.480
31.610
31.580
31.550
31.620
31.650
31.750
31.850
31.880
32.080
32.180
32.280
32.350
32.380
32.450
32.650
32.750
32.850
32.880
32.920
32.900
33.000
33.000
33.100
33.100
33.300
33.400
33.500
33.600
1967-10-01
1967-11-01
1967-12-01
1968-01-01
1968-02-01
1968-03-01
1968-04-01
1968-05-01
1968-06-01
1968-07-01
1968-08-01
1968-09-01
1968-10-01
1968-11-01
1968-12-01
1969-01-01
1969-02-01
1969-03-01
1969-04-01
1969-05-01
1969-06-01
1969-07-01
1969-08-01
1969-09-01
1969-10-01
1969-11-01
1969-12-01
1970-01-01
1970-02-01
1970-03-01
1970-04-01
1970-05-01
1970-06-01
1970-07-01
1970-08-01
1970-09-01
1970-10-01
1970-11-01
1970-12-01
1971-01-01
1971-02-01
1971-03-01
1971-04-01
1971-05-01
1971-06-01
1971-07-01
1971-08-01
1971-09-01
1971-10-01
1971-11-01
1971-12-01
1972-01-01
33.700
33.900
34.000
34.100
34.200
34.300
34.400
34.500
34.700
34.900
35.000
35.100
35.300
35.400
35.600
35.700
35.800
36.100
36.300
36.400
36.600
36.800
36.900
37.100
37.300
37.500
37.700
37.900
38.100
38.300
38.500
38.600
38.800
38.900
39.000
39.200
39.400
39.600
39.800
39.900
39.900
40.000
40.100
40.300
40.500
40.600
40.700
40.800
40.900
41.000
41.100
41.200
1972-02-01
1972-03-01
1972-04-01
1972-05-01
1972-06-01
1972-07-01
1972-08-01
1972-09-01
1972-10-01
1972-11-01
1972-12-01
1973-01-01
1973-02-01
1973-03-01
1973-04-01
1973-05-01
1973-06-01
1973-07-01
1973-08-01
1973-09-01
1973-10-01
1973-11-01
1973-12-01
1974-01-01
1974-02-01
1974-03-01
1974-04-01
1974-05-01
1974-06-01
1974-07-01
1974-08-01
1974-09-01
1974-10-01
1974-11-01
1974-12-01
1975-01-01
1975-02-01
1975-03-01
1975-04-01
1975-05-01
1975-06-01
1975-07-01
1975-08-01
1975-09-01
1975-10-01
1975-11-01
1975-12-01
1976-01-01
1976-02-01
1976-03-01
1976-04-01
1976-05-01
41.400
41.400
41.500
41.600
41.700
41.800
41.900
42.100
42.200
42.400
42.500
42.700
43.000
43.400
43.700
43.900
44.200
44.200
45.000
45.200
45.600
45.900
46.300
46.800
47.300
47.800
48.100
48.600
49.000
49.300
49.900
50.600
51.000
51.500
51.900
52.300
52.600
52.800
53.000
53.100
53.500
54.000
54.200
54.600
54.900
55.300
55.600
55.800
55.900
56.000
56.100
56.400
1976-06-01
1976-07-01
1976-08-01
1976-09-01
1976-10-01
1976-11-01
1976-12-01
1977-01-01
1977-02-01
1977-03-01
1977-04-01
1977-05-01
1977-06-01
1977-07-01
1977-08-01
1977-09-01
1977-10-01
1977-11-01
1977-12-01
1978-01-01
1978-02-01
1978-03-01
1978-04-01
1978-05-01
1978-06-01
1978-07-01
1978-08-01
1978-09-01
1978-10-01
1978-11-01
1978-12-01
1979-01-01
1979-02-01
1979-03-01
1979-04-01
1979-05-01
1979-06-01
1979-07-01
1979-08-01
1979-09-01
1979-10-01
1979-11-01
1979-12-01
1980-01-01
1980-02-01
1980-03-01
1980-04-01
1980-05-01
1980-06-01
1980-07-01
1980-08-01
1980-09-01
56.700
57.000
57.300
57.600
57.900
58.100
58.400
58.700
59.300
59.600
60.000
60.200
60.500
60.800
61.100
61.300
61.600
62.000
62.300
62.700
63.000
63.400
63.900
64.500
65.000
65.500
65.900
66.500
67.100
67.500
67.900
68.500
69.200
69.900
70.600
71.400
72.200
73.000
73.700
74.400
75.200
76.000
76.900
78.000
79.000
80.100
80.900
81.700
82.500
82.600
83.200
83.900
1980-10-01
1980-11-01
1980-12-01
1981-01-01
1981-02-01
1981-03-01
1981-04-01
1981-05-01
1981-06-01
1981-07-01
1981-08-01
1981-09-01
1981-10-01
1981-11-01
1981-12-01
1982-01-01
1982-02-01
1982-03-01
1982-04-01
1982-05-01
1982-06-01
1982-07-01
1982-08-01
1982-09-01
1982-10-01
1982-11-01
1982-12-01
1983-01-01
1983-02-01
1983-03-01
1983-04-01
1983-05-01
1983-06-01
1983-07-01
1983-08-01
1983-09-01
1983-10-01
1983-11-01
1983-12-01
1984-01-01
1984-02-01
1984-03-01
1984-04-01
1984-05-01
1984-06-01
1984-07-01
1984-08-01
1984-09-01
1984-10-01
1984-11-01
1984-12-01
1985-01-01
84.700
85.600
86.400
87.200
88.000
88.600
89.100
89.700
90.500
91.500
92.200
93.100
93.400
93.800
94.100
94.400
94.700
94.700
95.000
95.900
97.000
97.500
97.700
97.700
98.100
98.000
97.700
97.900
98.000
98.100
98.800
99.200
99.400
99.800
100.100
100.400
100.800
101.100
101.400
102.100
102.600
102.900
103.300
103.500
103.700
104.100
104.400
104.700
105.100
105.300
105.500
105.700
1985-02-01
1985-03-01
1985-04-01
1985-05-01
1985-06-01
1985-07-01
1985-08-01
1985-09-01
1985-10-01
1985-11-01
1985-12-01
1986-01-01
1986-02-01
1986-03-01
1986-04-01
1986-05-01
1986-06-01
1986-07-01
1986-08-01
1986-09-01
1986-10-01
1986-11-01
1986-12-01
1987-01-01
1987-02-01
1987-03-01
1987-04-01
1987-05-01
1987-06-01
1987-07-01
1987-08-01
1987-09-01
1987-10-01
1987-11-01
1987-12-01
1988-01-01
1988-02-01
1988-03-01
1988-04-01
1988-05-01
1988-06-01
1988-07-01
1988-08-01
1988-09-01
1988-10-01
1988-11-01
1988-12-01
1989-01-01
1989-02-01
1989-03-01
1989-04-01
1989-05-01
106.300
106.800
107.000
107.200
107.500
107.700
107.900
108.100
108.500
109.000
109.500
109.900
109.700
109.100
108.700
109.000
109.400
109.500
109.600
110.000
110.200
110.400
110.800
111.400
111.800
112.200
112.700
113.000
113.500
113.800
114.300
114.700
115.000
115.400
115.600
116.000
116.200
116.500
117.200
117.500
118.000
118.500
119.000
119.500
119.900
120.300
120.700
121.200
121.600
122.200
123.100
123.700
1989-06-01
1989-07-01
1989-08-01
1989-09-01
1989-10-01
1989-11-01
1989-12-01
1990-01-01
1990-02-01
1990-03-01
1990-04-01
1990-05-01
1990-06-01
1990-07-01
1990-08-01
1990-09-01
1990-10-01
1990-11-01
1990-12-01
1991-01-01
1991-02-01
1991-03-01
1991-04-01
1991-05-01
1991-06-01
1991-07-01
1991-08-01
1991-09-01
1991-10-01
1991-11-01
1991-12-01
1992-01-01
1992-02-01
1992-03-01
1992-04-01
1992-05-01
1992-06-01
1992-07-01
1992-08-01
1992-09-01
1992-10-01
1992-11-01
1992-12-01
1993-01-01
1993-02-01
1993-03-01
1993-04-01
1993-05-01
1993-06-01
1993-07-01
1993-08-01
1993-09-01
124.100
124.500
124.500
124.800
125.400
125.900
126.300
127.500
128.000
128.600
128.900
129.100
129.900
130.500
131.600
132.500
133.400
133.700
134.200
134.700
134.800
134.800
135.100
135.600
136.000
136.200
136.600
137.000
137.200
137.800
138.200
138.300
138.600
139.100
139.400
139.700
140.100
140.500
140.800
141.100
141.700
142.100
142.300
142.800
143.100
143.300
143.800
144.200
144.300
144.500
144.800
145.000
1993-10-01
1993-11-01
1993-12-01
1994-01-01
1994-02-01
1994-03-01
1994-04-01
1994-05-01
1994-06-01
1994-07-01
1994-08-01
1994-09-01
1994-10-01
1994-11-01
1994-12-01
1995-01-01
1995-02-01
1995-03-01
1995-04-01
1995-05-01
1995-06-01
1995-07-01
1995-08-01
1995-09-01
1995-10-01
1995-11-01
1995-12-01
1996-01-01
1996-02-01
1996-03-01
1996-04-01
1996-05-01
1996-06-01
1996-07-01
1996-08-01
1996-09-01
1996-10-01
1996-11-01
1996-12-01
1997-01-01
1997-02-01
1997-03-01
1997-04-01
1997-05-01
1997-06-01
1997-07-01
1997-08-01
1997-09-01
1997-10-01
1997-11-01
1997-12-01
1998-01-01
145.600
146.000
146.300
146.300
146.700
147.100
147.200
147.500
147.900
148.400
149.000
149.300
149.400
149.800
150.100
150.500
150.900
151.200
151.800
152.100
152.400
152.600
152.900
153.100
153.500
153.700
153.900
154.700
155.000
155.500
156.100
156.400
156.700
157.000
157.200
157.700
158.200
158.700
159.100
159.400
159.700
159.800
159.900
159.900
160.200
160.400
160.800
161.200
161.500
161.700
161.800
162.000
1998-02-01
1998-03-01
1998-04-01
1998-05-01
1998-06-01
1998-07-01
1998-08-01
1998-09-01
1998-10-01
1998-11-01
1998-12-01
1999-01-01
1999-02-01
1999-03-01
1999-04-01
1999-05-01
1999-06-01
1999-07-01
1999-08-01
1999-09-01
1999-10-01
1999-11-01
1999-12-01
2000-01-01
2000-02-01
2000-03-01
2000-04-01
2000-05-01
2000-06-01
2000-07-01
2000-08-01
2000-09-01
2000-10-01
2000-11-01
2000-12-01
2001-01-01
2001-02-01
2001-03-01
2001-04-01
2001-05-01
2001-06-01
2001-07-01
2001-08-01
2001-09-01
2001-10-01
2001-11-01
2001-12-01
2002-01-01
2002-02-01
2002-03-01
2002-04-01
2002-05-01
162.000
162.000
162.200
162.600
162.800
163.200
163.400
163.500
163.900
164.100
164.400
164.700
164.700
164.800
165.900
166.000
166.000
166.700
167.100
167.800
168.100
168.400
168.800
169.300
170.000
171.000
170.900
171.200
172.200
172.700
172.700
173.600
173.900
174.200
174.600
175.600
176.000
176.100
176.400
177.300
177.700
177.400
177.400
178.100
177.600
177.500
177.400
177.700
178.000
178.500
179.300
179.500
2002-06-01
2002-07-01
2002-08-01
2002-09-01
2002-10-01
2002-11-01
2002-12-01
2003-01-01
2003-02-01
2003-03-01
2003-04-01
2003-05-01
2003-06-01
2003-07-01
2003-08-01
2003-09-01
2003-10-01
2003-11-01
2003-12-01
2004-01-01
2004-02-01
2004-03-01
2004-04-01
2004-05-01
2004-06-01
2004-07-01
2004-08-01
2004-09-01
2004-10-01
2004-11-01
2004-12-01
2005-01-01
2005-02-01
2005-03-01
2005-04-01
2005-05-01
2005-06-01
2005-07-01
2005-08-01
2005-09-01
2005-10-01
2005-11-01
2005-12-01
2006-01-01
2006-02-01
2006-03-01
2006-04-01
2006-05-01
2006-06-01
2006-07-01
2006-08-01
2006-09-01
179.600
180.000
180.500
180.800
181.200
181.500
181.800
182.600
183.600
183.900
183.200
182.900
183.100
183.700
184.500
185.100
184.900
185.000
185.500
186.300
186.700
187.100
187.400
188.200
188.900
189.100
189.200
189.800
190.800
191.700
191.700
191.600
192.400
193.100
193.700
193.600
193.700
194.900
196.100
198.800
199.100
198.100
198.100
199.300
199.400
199.700
200.700
201.300
201.800
202.900
203.800
202.800
2006-10-01
2006-11-01
2006-12-01
2007-01-01
2007-02-01
2007-03-01
2007-04-01
2007-05-01
2007-06-01
2007-07-01
2007-08-01
2007-09-01
2007-10-01
2007-11-01
2007-12-01
2008-01-01
2008-02-01
2008-03-01
2008-04-01
2008-05-01
2008-06-01
2008-07-01
2008-08-01
2008-09-01
2008-10-01
2008-11-01
2008-12-01
2009-01-01
2009-02-01
2009-03-01
2009-04-01
2009-05-01
2009-06-01
2009-07-01
2009-08-01
2009-09-01
2009-10-01
2009-11-01
2009-12-01
2010-01-01
2010-02-01
2010-03-01
2010-04-01
2010-05-01
2010-06-01
2010-07-01
2010-08-01
2010-09-01
2010-10-01
2010-11-01
2010-12-01
2011-01-01
201.900
202.000
203.100
203.437
204.226
205.288
205.904
206.755
207.234
207.603
207.667
208.547
209.190
210.834
211.445
212.174
212.687
213.448
213.942
215.208
217.463
219.016
218.690
218.877
216.995
213.153
211.398
211.933
212.705
212.495
212.709
213.022
214.790
214.726
215.445
215.861
216.509
217.234
217.347
217.488
217.281
217.353
217.403
217.290
217.199
217.605
217.923
218.275
219.035
219.590
220.472
221.187
2011-02-01
2011-03-01
2011-04-01
2011-05-01
2011-06-01
2011-07-01
2011-08-01
2011-09-01
2011-10-01
2011-11-01
2011-12-01
2012-01-01
2012-02-01
2012-03-01
2012-04-01
2012-05-01
2012-06-01
2012-07-01
2012-08-01
2012-09-01
2012-10-01
2012-11-01
2012-12-01
2013-01-01
2013-02-01
2013-03-01
2013-04-01
2013-05-01
2013-06-01
2013-07-01
2013-08-01
2013-09-01
2013-10-01
2013-11-01
2013-12-01
2014-01-01
2014-02-01
2014-03-01
2014-04-01
2014-05-01
2014-06-01
2014-07-01
2014-08-01
2014-09-01
2014-10-01
2014-11-01
2014-12-01
2015-01-01
2015-02-01
2015-03-01
2015-04-01
2015-05-01
221.898
223.046
224.093
224.806
224.806
225.395
226.106
226.597
226.750
227.169
227.223
227.842
228.329
228.807
229.187
228.713
228.524
228.590
229.918
231.015
231.638
231.249
231.221
231.612
232.985
232.299
231.795
231.916
232.374
232.889
233.323
233.632
233.718
234.121
234.723
235.385
235.672
235.978
236.471
236.832
237.029
237.424
237.256
237.486
237.506
237.118
236.290
234.913
235.489
235.989
236.201
236.891
2015-06-01
2015-07-01
2015-08-01
2015-09-01
2015-10-01
2015-11-01
2015-12-01
2016-01-01
2016-02-01
2016-03-01
2016-04-01
2016-05-01
2016-06-01
2016-07-01
2016-08-01
2016-09-01
2016-10-01
2016-11-01
2016-12-01
2017-01-01
2017-02-01
2017-03-01
237.419
237.876
237.811
237.467
237.792
238.153
237.846
238.106
237.808
238.078
238.908
239.362
239.842
239.898
240.389
241.006
241.694
242.199
242.821
244.158
244.456
243.752
1982-1984=100, Monthly, Seasonally Adjusted
Date
CPI
Percent Change
Percent Change Using %
Formatting Within Excel
3/1/2011
4/1/2011
5/1/2011
6/1/2011
7/1/2011
8/1/2011
9/1/2011
10/1/2011
11/1/2011
12/1/2011
1/1/2012
2/1/2012
3/1/2012
4/1/2012
5/1/2012
6/1/2012
7/1/2012
8/1/2012
9/1/2012
10/1/2012
11/1/2012
12/1/2012
1/1/2013
2/1/2013
3/1/2013
4/1/2013
5/1/2013
6/1/2013
7/1/2013
8/1/2013
9/1/2013
10/1/2013
11/1/2013
12/1/2013
1/1/2014
2/1/2014
3/1/2014
4/1/2014
5/1/2014
6/1/2014
7/1/2014
8/1/2014
9/1/2014
10/1/2014
11/1/2014
12/1/2014
1/1/2015
2/1/2015
3/1/2015
4/1/2015
5/1/2015
6/1/2015
7/1/2015
223.046
224.093
224.806
224.806
225.395
226.106
226.597
226.75
227.169
227.223
227.842
228.329
228.807
229.187
228.713
228.524
228.59
229.918
231.015
231.638
231.249
231.221
231.612
232.985
232.299
231.795
231.916
232.374
232.889
233.323
233.632
233.718
234.121
234.723
235.385
235.672
235.978
236.471
236.832
237.029
237.424
237.256
237.486
237.506
237.118
236.29
234.913
235.489
235.989
236.201
236.891
237.419
237.876
0.469409898
0.318171473
0
0.262003683
0.315446217
0.217154786
0.067520753
0.184785006
0.023770849
0.272419605
0.213744612
0.209347039
0.166078835
-0.206818013
-0.082636317
0.028880993
0.580952798
0.477126628
0.269679458
-0.167934449
-0.01210816
0.169102287
0.592801755
-0.294439556
-0.21696176
0.052201299
0.197485296
0.221625483
0.186354873
0.132434436
0.036810026
0.172430023
0.257131996
0.282034568
0.121927905
0.129841475
0.20891778
0.152661426
0.083181327
0.166646275
-0.070759485
0.0969417
0.008421549
-0.163364294
-0.349193229
-0.582758475
0.245197158
0.212324143
0.089834696
0.292124081
0.222887319
0.192486701
0.469409898%
0.318171473%
0.000000000%
0.262003683%
0.315446217%
0.217154786%
0.067520753%
0.184785006%
0.023770849%
0.272419605%
0.213744612%
0.209347039%
0.166078835%
-0.206818013%
-0.082636317%
0.028880993%
0.580952798%
0.477126628%
0.269679458%
-0.167934449%
-0.012108160%
0.169102287%
0.592801755%
-0.294439556%
-0.216961760%
0.052201299%
0.197485296%
0.221625483%
0.186354873%
0.132434436%
0.036810026%
0.172430023%
0.257131996%
0.282034568%
0.121927905%
0.129841475%
0.208917780%
0.152661426%
0.083181327%
0.166646275%
-0.070759485%
0.096941700%
0.008421549%
-0.163364294%
-0.349193229%
-0.582758475%
0.245197158%
0.212324143%
0.089834696%
0.292124081%
0.222887319%
0.192486701%
8/1/2015
9/1/2015
10/1/2015
11/1/2015
12/1/2015
1/1/2016
2/1/2016
3/1/2016
4/1/2016
5/1/2016
6/1/2016
7/1/2016
8/1/2016
9/1/2016
10/1/2016
11/1/2016
12/1/2016
1/1/2017
2/1/2017
3/1/2017
237.811
237.467
237.792
238.153
237.846
238.106
237.808
238.078
238.908
239.362
239.842
239.898
240.389
241.006
241.694
242.199
242.821
244.158
244.456
243.752
-0.027325161
-0.144652686
0.136861122
0.151813349
-0.128908727
0.10931443
-0.125154343
0.113536971
0.34862524
0.190031309
0.200533084
0.023348705
0.204670318
0.256667318
0.285470071
0.208941885
0.256813612
0.550611356
0.122052114
-0.287986386
-0.027325161%
-0.144652686%
0.136861122%
0.151813349%
-0.128908727%
0.109314430%
-0.125154343%
0.113536971%
0.348625240%
0.190031309%
0.200533084%
0.023348705%
0.204670318%
0.256667318%
0.285470071%
0.208941885%
0.256813612%
0.550611356%
0.122052114%
-0.287986386%
0.800000000%
The Period 1/1/13
highest inflation rate. The inflation rate was
.592801755
0.600000000%
0.400000000%
0.200000000%
-0.400000000%
-0.600000000%
-0.800000000%
6/1/2014
4/1/2014
2/1/2014
12/1/2013
10/1/2013
8/1/2013
6/1/2013
4/1/2013
2/1/2013
12/1/2012
10/1/2012
8/1/2012
6/1/2012
4/1/2012
2/1/2012
12/1/2011
8/1/2011
10/1/2011
-0.200000000%
6/1/2011
4/1/2011
0.000000000%
2/1/2017
12/1/2016
10/1/2016
8/1/2016
6/1/2016
4/1/2016
2/1/2016
12/1/2015
10/1/2015
8/1/2015
6/1/2015
4/1/2015
2/1/2015
12/1/2014
10/1/2014
8/1/2014
6/1/2014
Period 1/1/13 - 2/1/13 experienced the
ghest inflation rate. The inflation rate was
Instructions:
Week 5 Individual Assignment
Total Number of Questions - 12
Total Points: 6
1. You have twelve problems - on each tab of this Excel file.
2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell.
The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropria
back and partial credit (if appropriate).
Find the interest paid on a loan of $1,200 for three years at a simple interest rate of 5% per year.
How much money will you pay after three years?
Principal
Rate
Time
Simple Interest (SI)
Maturity Value
=PRODUCT(B4:B6)
=Principal + SI
Find the maturity value of a loan of $1,750 for 28 months at 9.8% simple interest per year.
Principal
Rate
Time
Simple Interest (SI)
Maturity Value
-- Please make sure that the time periods for Time and Rate match.
=PRODUCT(B3:B5)
=Principal + SI
Find the simple interest rate of a loan of $5,000 that is made for three years and requires $1,762.50 in interest.
Principal
Time
SI
Rate
762.50 in interest.
A loan of $16,840 is borrowed at 9% simple interest and is
repaid with $4,167.90 interest. What is the duration of the loan?
Principal
Rate
SI
Time
How much money is borrowed if the interest rate is 9.25% simple interest
and the loan is made for 3.5 years and has $904.88 interest?
SI
Rate
Time
Principal
Find the ordinary and exact interest for a loan of $1000 at a 5% annual
interest rate. The loan was made on March 15 and is due May 15.
Loan date
Loan Due Date
Exact time
days
=B5-B4
Principal
Rate
Time
Loan date
Loan Due Date
Exact time
days
Principal
Rate
Time
Ordinary Simple Interest (SI)
Exact Simple Interest (SI)
=PRODUCT(B8:B10)
=PRODUCT(G8:G10)
=G5-G4
=PRODUCT(G8:G10)
Find the bank discount and proceeds using ordinary interest for a loan to Michelle Anders for $7,200
at 8.25% annual simple interest from August 8 to November 8.
Loan date
Loan Due Date
Exact time
days
Face Value (F)
Discount Rate (D)
Time Period (T)
Bank Discount (B)
years --> 'Convert Exact time in days to years
=PRODUCT(B8:B10) OR =B8*B9*B10
Proceeds (P)
=B8-B11
=B5-B4
What is the effective interest rate of a simple discount note for $8,000,
at an ordinary bank discount rate of 11%, for 120 days?
Face Value (F)
Discount Rate (D)
Time Period (T)
Bank Discount (B)
years --> 'Convert Exact time in days to years
=PRODUCT(B4:B6) OR =B4*B5*B6
Proceeds (P)
=B4 - B7
Rate
=B7/PRODUCT(B9, B6)
SOLVED EXAMPLE
What is the effective interest rate for the first year for a loan of $20,000
for three years if the interest is compounded quarterly at a rate of 12%?
Quoted Rate
12.00% quarterly
No. of compounding
periods per year
EAR
4 For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo
12.55% =EFFECT(B5, B6)
1. Ross Land has a loan of $8,500 compounded quarterly for four years at 6%. What is the effective interest rate for the first y
Quoted Rate
No. of compounding
periods per year
EAR
For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo
=EFFECT(B11, B12)
2. Find the effective interest rate for the first year for a loan for four years compounded semiannually at an annual rate of 2%
Quoted Rate
No. of compounding
periods per year
EAR
For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo
=EFFECT(B17, B18)
3. What is the effective interest rate for the first year for a loan of $5,000 at 10% compounded daily for three years?
Quoted Rate
No. of compounding
periods per year
EAR
For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo
=EFFECT(B23, B24)
4. Depending on the issuer, a typical credit card agreement quotes an interest rate of 18 percent APR. Monthly payments are
What is the actual interest rate you pay on such a credit card?
Quoted Rate
No. of compounding
periods per year
EAR
For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo
=EFFECT(B30, B31)
5. Find the effective interest rate for a loan of $3,500 at 10% interest compounded quarterly.
Quoted Rate
No. of compounding
periods per year
EAR
For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo
=EFFECT(B36, B37)
SOLVED EXAMPLE
Tim Bowling has $20,000 invested for three years at a 5.25% annual rate compounded daily.
How much interest will he earn?
Initial Investment (PV)
Quoted Rate
Compounding Frequency
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)
Compound Interest
$20,000
5.25%
Daily
365
0.0144%
3
1095
$23,411.35
$3,411.35
Choose one
For Quarterly, type 4; for semiannually, type 2; for a
Exercise
Find the future value of a $15,000 money market investment at 2.8% annual interest compounded daily for three years.
Initial Investment (PV)
Quoted Rate
Compounding Frequency
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)
Compound Interest
Choose one
For Quarterly, type 4; for semiannually, type 2; for a
for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
SOLVED EXAMPLE
The Holiday Boutique would like to put away some of the holiday
profits to save for a planned expansion. A total of $8,000 is needed in three years. How much
money in a 5.2% three-year certificate of deposit that is compounded monthly must be invested
now to have the $8,000 in three years?
Future Value Needed (FV)
Quoted Rate
Compounding Frequency
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Amount Invested Now (PV)
$8,000
5.2%
Monthly
12
0.4333%
3
36
$6,846.78
Choose one
For Quarterly, type 4; for semiannually, type 2; for a
Exercise
How much should be invested now to have $15,000 in six years if interest is 4% compounded quarterly?
Future Value Needed (FV)
Quoted Rate
Compounding Frequency
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Amount Invested Now (PV)
Choose one
For Quarterly, type 4; for semiannually, type 2; for a
r semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
r semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
Jamie Juarez needs $12,000 in 10 years for her daughter’s college education.
How much must be invested today at 2% annual interest compounded
semiannually to have the needed funds?
Future Value Needed (FV)
Quoted Rate
Compounding Frequency
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Amount Invested Now (PV)
Choose one
For Quarterly, type 4; for semiannually, type 2; for annually, ty
A loan of $8,000 for two acres of woodland is compounded quarterly at an annual
rate of 6% for five years. Find the compound amount and the compound interest.
Initial Investment (PV)
Quoted Rate
Compounding Frequency
Number of compoundings (m)
Quoted Rate divided by m = RATE
Number of Years
NPER (Num. of years * m)
Ending Amount (FV)
Compound Interest
Choose one
For Quarterly, type 4; for semiannually, type 2; for annually, ty
ually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
ually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365
Instructions:
Week 4 Individual Assignment
Total Number of Questions - 12
1. You have twelve problems - one on each tab of this Excel file.
2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell.
The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropria
back and partial credit (if appropriate).
Fifty business students were given a project to complete. The bar graph below shows the number
of days it took the students to complete the assignment.
1. How many students took 4 days to comple
2. How many students completed the projec
3. What percent of students completed the p
ny students took 4 days to complete the assignment?
ny students completed the project in 3 days or less?
rcent of students completed the project in 3 days or less?
State the answer as a percentage with one digit after decimal.
The bar graph below shows the Quarterly Dollar Volume of Batesville Tire Company.
Refer to the bar graph below and answer the questions.
1. Which quarter had the highest dollar volum
2. What percent of the yearly sales were the
3. What was the percent of increase in sales
rcent of the yearly sales were the sales for October–December?
State the answer as a percentage with one digit after decimal.
as the percent of increase in sales from the first to the second quarter?
State the answer as a percentage with one digit after decimal.
git after decimal.
The line chart below shows data for Automobile Gasoline Mileage Comparisons for
full-size and compact cars.
Refer to the chart and answer the questions.
1. What speed gave the highest g
2. What speed gave the lowest ga
3. At what speed did the first not
Which car showed this decrease?
1. What speed gave the highest gasoline mileage for both types of automobiles?
2. What speed gave the lowest gasoline mileage for both types of automobiles?
3. At what speed did the first noticeable decrease in gasoline mileage occur?
Choose one
The line chart below shows Dale Crosby's Salary History.
Refer to this chart and answer the questions.
1. Calculate the amount and percent of increase in Dale’
Amount of increase
2. What is the percent of increase in Dale’s salary from 2
Percentage of increase
3. Calculate the amount and percent of increase in Dale’
Amount of increase
4. If the cost-of-living increase was 10% from 2011 to 20
salary for this period of time kept pace with inflation.
Hint: For part 4, follow the steps below:
Step 1: Find the amount of salary increase from 2011 to
Step 2: Find the percentage increase from 2011 to 2016
Step 3: If the percentage increase from Step 2 is greater
Dale's salary kept pace with inflation, otherwise no.
Step 1: Amount of salary increase from 2011 to 2016
Step 2: Percentage increase from 2011 to 2016
Step 3: Did the salary keep pace with inflation?
nd percent of increase in Dale’s salary from 2014 to 2015.
Percentage of increase
State the answer as a percentage with one digit after decima
increase in Dale’s salary from 2012 to 2013?
State the answer as a percentage with one digit after decimal.
nd percent of increase in Dale’s salary from 2016 to 2017.
Percentage of increase
State the answer as a percentage with one digit after decima
ease was 10% from 2011 to 2016, determine if Dale’s
me kept pace with inflation.
of salary increase from 2011 to 2016.
ge increase from 2011 to 2016.
increase from Step 2 is greater than 10% cost-of-living increase, then
th inflation, otherwise no.
increase from 2011 to 2016
State the answer as a percentage with no decimal.
(Choose one)
with one digit after decimal.
with one digit after decimal.
The pie chart below shows the family budget. Refer to the chart and answer the following questions.
1. What is the total take-home pay?
2. What percent of the total take-home pay
3. What percent of the take-home pay is allo
4. What percent of take-home pay is spent fo
5. What percent of take-home pay is spent fo
savings, and miscellaneous funds are combin
Total of education, savings, and miscellaneou
Percentage of take-home pay spent on this c
rcent of the total take-home pay is allocated for transportation?
State the answer as a percentage with one digit after decimal.
rcent of the take-home pay is allocated for food?
State the answer as a percentage with one digit after decimal.
rcent of take-home pay is spent for education?
State the answer as a percentage with one digit after decimal.
rcent of take-home pay is spent for education when education,
d miscellaneous funds are combined to be used for education?
e of take-home pay spent on this combined total
State the answer as a percentage with one digit after decimal.
with one digit after decimal.
The bar chart shows the distribution of tax dollars. Refer to the chart and answer the following questions.
1. What expenditure is expected to be the sa
2. What two expenditures are expected to in
3. What two expenditures are expected to d
4. What expenditure was greatest both years
penditure is expected to be the same next year as this year?
The Canmark Research Center Airport Customer Satisfaction Survey uses an online questionnaire to provide airlines and airpo
customer satisfaction ratings for all aspects of the customers’ flight experience (airportsurvey website, July 2012). After comp
flight, customers receive an e-mail asking them to go to the website and rate a variety of factors, including the reservation pr
the check-in process, luggage policy, cleanliness of gate area, service by flight attendants, food/beverage selection, on-time a
and so on. A five-point scale, with Excellent, Very Good, Good, Fair, and Poor, is used to record customer ratings. Assume
that passengers on a delta Airlines flight from Myrtle beach, South Carolina, to Atlanta, Georgia, provided the following rating
question, “Please rate the airline based on your overall experience with this flight.” The sample ratings are shown below.
Rating
Excellent
Excellent
Very Good
Good
Excellent
Excellent
Good
Very Good
Excellent
Excellent
Good
Very Good
Very Good
Very Good
Very Good
Very Good
Excellent
Fair
Excellent
Very Good
Very Good
Excellent
Very Good
Very Good
Excellent
Excellent
Very Good
Excellent
Excellent
Poor
Very Good
Excellent
Very Good
Very Good
Excellent
Very Good
Excellent
Excellent
Credit: Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2017). Statistics f
1. Use the pivot table feature in Microsoft Excel and create a frequency distribution with two column
2. Use Excel to create a bar chart (or a pivot bar chart)
3. Use Excel to create a pie chart (or a pivot pie chart)
4. Interpret information from the charts and the frequency distribution.
Very Good
Very Good
Very Good
Excellent
Good
Very Good
Poor
Excellent
Very Good
Excellent
Very Good
Very Good
& Cochran, J. J. (2017). Statistics for business & economics 13e. Boston: Cengage Learning.
The data below shows the total sales per day of the week by four salespersons.
Use Microsoft Excel to construct a line chart (graph)showing total sales by the days
of the week for Happy's Gift Shoppe.
Mon
Tue
Wed
Thu
Fri
Sat
Sales
$233,94
$352,55
$355,16
$542,18
$369,01
$611,77
Which day of the week constituted highest sales?
Use Excel to find the mean, median, and mode of the scores given below.
92
68
72
83
72
95
88
76
72
89
89
96
74
72
Mean
Median
Mode
After your MBA, you are employed as a business analyst for a company that makes household products,
which are sold by part-time salespersons who work during their spare time. The company has four
salespersons employed. Let us denote these salespersons by A, B, C, and D. The sales records (in dollars)
for the past 6 weeks for these four salespersons are shown in the table below.
Week
1
2
3
4
5
6
A
1774
1808
1890
1932
1855
1726
B
2205
1507
2352
1939
2052
1630
C
1330
1295
1502
1104
1189
1441
D
1402
1665
1530
1826
1703
1498
Your supervisor has asked you to prepare a brief analysis comparing the sales volumes and the consistency
of sales of these four salespersons. Use the mean sales for each salesperson to compare the sales volumes,
and then choose an appropriate statistical measure to compare the consistency of sales.
Week
1
2
3
4
5
6
A
1774
1808
1890
1932
1855
1726
B
2205
1507
2352
1939
2052
1630
C
1330
1295
1502
1104
1189
1441
D
1402
1665
1530
1826
1703
1498
Mean
Median
MIN
MAX
Range
Std Dev
Variance
Case Adapted from Introductory Statistics, 8e, Mann
old products,
ds (in dollars)
the consistency
e sales volumes,
The data below shows personal income for Quarters 2014: II - 2015: III in millions of dollars, seasonally
adjusted at annual rate.
Quarter II, 2014
Quarter III, 2014
Quarter IV, 2014
Quarter I, 2015
Quarter II, 2015
Quarter III, 2015
$14.603.925
$14.784.309
$14.925.215
$15.056.970
$15.254.088
$15.449.647
After plotting the line graph, answer the following questions:
1. Is the graph exhibiting an increasing, decreasing, or fluctuating trend?
Choose one
2. Which quarter showed the highest personal income?
Construct a pie chart (circle graph) showing the distribution of market share using the data below.
The data represents the percent dollar market of comics and magazine sales for September (Rounded
to the nearest whole percent).
Publisher
Marvel Comics
DC Comics
Image Comics
Dark Horse Comics
Dreamweave Productions
All others
Market Share
35%
32%
5%
4%
4%
20%
After plotting the pie chart, answer the following questions.
1. What percent of market share is held by the largest three compa
2. What was Image Comics' sales for September if the total market
3. If the total market had $80,000,000 in comics and magazine sales
Purchase answer to see full
attachment