Topic_2_DQ_2 Alexandra oeswein
xlsx
keyboard_arrow_up
School
Lone Star College System, Woodlands *
*We aren’t endorsed by this school
Course
144
Subject
Mathematics
Date
Apr 3, 2024
Type
xlsx
Pages
5
Uploaded by alexoeswein
Excel Skills Learned
There are no new Excel skills here.
Math Skills Learned
Instructi
Projectio
entering
legend a
1. Percentage change. In particular, inflation rate as the percent change in CPI.
2. Projecting future income based on the inflation rate. Projecting a future value based on percentage change.
tions
: Open the tab labeled "Inflation Rate & on" and complete the tasks indicated there. Start by g your name where indicated. Pay attention to the and note that the sheet is self-checking.
Enter your name in C2 ⇒
Alexandra
At least five letters.
#NAME?
247.867
#NAME?
#NAME?
261.582
#NAME?
#NAME?
5.53%
New/Original - 1
#NAME?
#NAME?
#NAME?
$15.00
#NAME?
$15.83
P*(1 + r)
#NAME?
Projected Weekly Income
$633.20
Projected Weekly Income
Part 1: Using the CPI values from the website below, find the inflation rates for the indicated time perio
1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi-bin/surveymost?cu 2. Check the box to the left of text "U.S. city average, All items - CUUR0000SA0"
3. Press the "Retrieve Data" button at the bottom of the list and a table of CPI values will appear.
4. Record your CPI values in the green cells.
5. Find the 3-Year and 1-Year Inflation Rates based on the CPI values.
6. Format CPI values as Numbers with 3 decimal places and the inflation rates as a percentage with 2 d
Video Explanation
CPI Valu
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Legend
If a cell is shaded
You should
Blue
Green
Enter a number
Gold
Any other color
Make no changes
15
A formula was used, but the
15
A formula should have been
16
A formula should have been
16
A formula was used, and the
247.867
251.712
1.55%
New/Original - 1
$15.71
P*(1 + r)³ $628.36
od.
ecimal places. Enter a text response
Enter an Excel formula
ues
e value is incorrect.
n used, and the value is incorrect.
n used, but the value is correct.
e value is correct.