EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 2PE
To determine
To create a line chart showing the growth in the annual CPI.
Expert Solution & Answer
Explanation of Solution
Given:
The Consumer price index excel file data is as follows:
| Consumer Price Index - All Urban Consumers | Bureau of Labor Statistics | |||||||||||
| Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| 2000 | 169.300 | 170.000 | 171.000 | 170.900 | 171.200 | 172.200 | 172.700 | 172.700 | 173.600 | 173.900 | 174.200 | 174.600 |
| 2001 | 175.600 | 176.000 | 176.100 | 176.400 | 177.300 | 177.700 | 177.400 | 177.400 | 178.100 | 177.600 | 177.500 | 177.400 |
| 2002 | 177.700 | 178.000 | 178.500 | 179.300 | 179.500 | 179.600 | 180.000 | 180.500 | 180.800 | 181.200 | 181.500 | 181.800 |
| 2003 | 182.600 | 183.600 | 183.900 | 183.200 | 182.900 | 183.100 | 183.700 | 184.500 | 185.100 | 184.900 | 185.000 | 185.500 |
| 2004 | 186.300 | 186.700 | 187.100 | 187.400 | 188.200 | 188.900 | 189.100 | 189.200 | 189.800 | 190.800 | 191.700 | 191.700 |
| 2005 | 191.600 | 192.400 | 193.100 | 193.700 | 193.600 | 193.700 | 194.900 | 196.1000 | 198.800 | 199.100 | 198.100 | 198.100 |
| 2006 | 199.200 | 199.400 | 199.700 | 200.600 | 201.400 | 201.900 | 202.900 | 203.700 | 202.900 | 201.800 | 202.000 | 203.100 |
| 2007 | 203.372 | 204.258 | 205.312 | 205.959 | 206.850 | 207.202 | 207.651 | 207.671 | 208.503 | 209.073 | 210.740 | 211.434 |
| 2008 | 212.225 | 212.703 | 213.543 | 214.106 | 215.287 | 217.279 | 219.102 | 218.779 | 218.846 | 216.832 | 212.923 | 211.339 |
| 2009 | 211.959 | 212.877 | 212.643 | 212.810 | 213.050 | 214.558 | 214.774 | 215.566 | 215.911 | 216.357 | 216.859 | 217.224 |
| 2010 | 217.587 | 217.591 | 217.729 | 217.579 | 217.224 | 216.929 | 217.597 | 218.150 | ||||
Calculation:
Since, we have to show the line chart for the growth in annual CPI. Thus, we have to take the sum of the months yearly basis. We will use the formula for sum, such as,
=SUM(number1,[number2],...])
Thus the result will be as:
And the outcome will be:
| Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | CPI(Annualy) |
| 2000 | 169.300 | 170.000 | 171.000 | 170.900 | 171.200 | 172.200 | 172.700 | 172.700 | 173.600 | 173.900 | 174.200 | 174.600 | 2066.300 |
| 2001 | 175.600 | 176.000 | 176.100 | 176.400 | 177.300 | 177.700 | 177.400 | 177.400 | 178.100 | 177.600 | 177.500 | 177.400 | 2124.500 |
| 2002 | 177.700 | 178.000 | 178.500 | 179.300 | 179.500 | 179.600 | 180.000 | 180.500 | 180.800 | 181.200 | 181.500 | 181.800 | 2158.400 |
| 2003 | 182.600 | 183.600 | 183.900 | 183.200 | 182.900 | 183.100 | 183.700 | 184.500 | 185.100 | 184.900 | 185.000 | 185.500 | 2208.000 |
| 2004 | 186.300 | 186.700 | 187.100 | 187.400 | 188.200 | 188.900 | 189.100 | 189.200 | 189.800 | 190.800 | 191.700 | 191.700 | 2266.900 |
| 2005 | 191.600 | 192.400 | 193.100 | 193.700 | 193.600 | 193.700 | 194.900 | 196.1000 | 198.800 | 199.100 | 198.100 | 198.100 | 2343.200 |
| 2006 | 199.200 | 199.400 | 199.700 | 200.600 | 201.400 | 201.900 | 202.900 | 203.700 | 202.900 | 201.800 | 202.000 | 203.100 | 2418.600 |
| 2007 | 203.372 | 204.258 | 205.312 | 205.959 | 206.850 | 207.202 | 207.651 | 207.671 | 208.503 | 209.073 | 210.740 | 211.434 | 2488.025 |
| 2008 | 212.225 | 212.703 | 213.543 | 214.106 | 215.287 | 217.279 | 219.102 | 218.779 | 218.846 | 216.832 | 212.923 | 211.339 | 2582.964 |
| 2009 | 211.959 | 212.877 | 212.643 | 212.810 | 213.050 | 214.558 | 214.774 | 215.566 | 215.911 | 216.357 | 216.859 | 217.224 | 2574.588 |
| 2010 | 217.587 | 217.591 | 217.729 | 217.579 | 217.224 | 216.929 | 217.597 | 218.150 | 1740.386 |
Then, we will construct the line chart by selecting the last column of CPI (annually) of the sums of the months year wise and then go to the insert button and then click on the line chart and the line chart is created,
The line chart is as follows:
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Please could you check if my answers are correct
Not use ai please
Questions
19
Next
You have $4,500 on a credit card that charges a 19% interest rate. If you want to pay off the
credit card in 4 years, how much will you need to pay each month (assuming you don't charge
anything new to the card)?
$
each month
Question Help: Video Message instructor
Submit Question
esc
F1
F2
80
F3
F4
!
1
2
#3
$
4
55
%
F6
&
6
87
Q
W
E
R
T
Y
tab
A
caps lock
S
D
<
DII
F7
F8
כ
00
8
LL
F
G
H
J
(
S
H
Z
X
C
V
B
N
M
shift
fn
T
H
control
option
command
Chapter 3 Solutions
EBK BUSINESS ANALYTICS
Ch. 3 - Prob. 2PECh. 3 - Create a line chart for the closing prices for all...Ch. 3 - Create a pie chart showing the breakdown of...Ch. 3 - Create a stacked area chart contrasting primary...Ch. 3 - A national homebuilder builds single-family homes...Ch. 3 - The Excel file Facebook Survey provides data...Ch. 3 - Create a bubble chart for the first five colleges...Ch. 3 - Construct a column chart for the data in the Excel...Ch. 3 - The Excel file Internet Usage provides data about...Ch. 3 - Construct an appropriate chart to show the...
Ch. 3 - A marketing researcher surveyed 92 individuals,...Ch. 3 - In the Excel file Banking Data, apply the...Ch. 3 - Apply three different colors of data bars to...Ch. 3 - For the Store and Regional Sales database, apply a...Ch. 3 - For the Excel file Closing Stock Prices, apply...Ch. 3 - Create a useful dashboard for the data in the...Ch. 3 - Create a useful dashboard for the data in the...Ch. 3 - Create a useful dashboard for the data in the...
Knowledge Booster
Similar questions
- Suppose you want to have $500,000 for retirement in 25 years. Your account earns 9% interest. How much would you need to deposit in the account each month? $ Question Help: Message instructor Submit Question esc F1 -0- F2 80 F3 F4 # $ 4 ! B 1 2 3 F5 لا F6 % ヘ6 olo5 A F7 DII FB 87 & 8 * 00 Ո G H J Q W E R T Y tab 2. A caps lock S D FL Z X C V B N shift fn T H control option commandarrow_forwardYou can afford a $1400 per month mortgage payment. You've found a 30 year loan at 8% interest. a) How big of a loan can you afford? $ b) How much total money will you pay the loan company? $ c) How much of that money is interest? Question Help: Video 1 Video 2 Message instructor Submit Question esc F1 F2 80 F3 a F4 #3 8 N 1 ! @ $ 4 F5 F6 % do 5 <6 DII F7 F8 87 & 8 * 00 U G H J Q W E R T Y tab 2. A caps lock shift fn D LL Z X C V B N M S control T H option commandarrow_forwardThe contingency table shows how a random sample of college freshmen graded the leaders of three types of institutions. At <= 0.05, can you conclude that the grades are related to the institution? Complete parts (a) through (d). Grade Institution A B C D/F Military 32 40 19 17 Religious 16 44 22 Media/Press 16 23 34 28 18 23 (a) Identify the claim and state the null and alternative hypotheses. Ho: Grades are the institution. H₂: Grades are the institution. The is the claim. (b) Determine the degrees of freedom, find the critical value, and identify the rejection region. What are the degrees of freedom? d.f. = Find the critical value. = (Round to three decimal places as needed.) Choose the correct rejection region below. OA OB. < OC. 2x OD. So (c) Calculate the test statistic. If convenient, use technology. x = ☐ (Round to two decimal places as needed.) (d) Decide to reject or fail to reject the null hypothesis. Then interpret the decision in the context of the original claim. Choose the…arrow_forward
- Frequency 8 2 1 6 11 16 21 26 31 data Based on the histogram above, what is the class width? Class width = What is the sample size? Sample size Question Help: Message instructor Submit Question esc F1 80 어 F2 F3 F4 F5 F6 2 1 ! 2 # 3 W SA $ % 4 go5 J > & 6arrow_forwardFrequency 4 2 8 1 6 11 1 21 21 26 18 data 31 Q Based on the histogram above, what is the class width? Class width What is the sample size? Sample size = Question Help: Message instructor Submit Question esc F1 F2 80 F3 A F4 F5 F6 F7 # $ SA do % Λ & 2 3 4 5 6 7 Q W E R T Y tab S C ה Iarrow_forwardThe city of Raleigh has 6700 registered voters. There are two candidates for city council in an upcoming election: Brown and Feliz. The day before the election, a telephone poll of 300 randomly selected registered voters was conducted. 178 said they'd vote for Brown, 92 said they'd vote for Feliz, and 30 were undecided. Give the sample statistic for the proportion of voters surveyed who said they'd vote for Brown. Note: The proportion should be a fraction or decimal, not a percent. This sample statistic suggests that we might expect registered voters to vote for Brown. Question Help: Video Message instructor Submit Question esc ~ 1 80 of the 6700 0 1 F1 F2 F3 F4 EA 2 3 4 어요 K D F5 F6 F7 % <6 do5 & 7 * 8 Q W E R T Y U tab A caps lock S Z X D C LL F G H J Carrow_forward
- You have $500,000 saved for retirement. Your account earns 7% interest. How much will you be able to pull out each month, if you want to be able to take withdrawals for 25 years? Enter an integer or decimal number [more..] Question Help: Submit Question esc Video Message instructor F1 F2 1 2 # 3 80 F3 F4 $ 4 5 olo LO % F5 6 > ˇ DI F6 F7 F Q W E R T Y A S D ck & 7 LL F G H 8 * 00 U Z X C V B N > T H trol option commandarrow_forwardA political scientist surveys 29 of the current 131 representatives in a state's legislature. What is the size of the sample: What is the size of the population: Question Help: Video 1 Video 2 Message instructor Submit Question esc ~ ! F1 F2 2 80 F3 F4 F5 F6 # $ 3 4 olo 5 % 1 6 7 Q W E R T Y tab A S D caps lock LL 8 FZ G Harrow_forwardSuppose you want to have $300,000 for retirement in 25 years. Your account earns 8% interest. a) How much would you need to deposit in the account each month? LA $ b) How much interest will you earn? tA $ Question Help: Video Message instructor Submit Question esc 2 1 F1 F2 2 80 F3 F4 F5 어요 SA <6 olo 5 % # 3 $ 4 Q W E R T F6arrow_forward
- Please solve this questionarrow_forwardA study was conducted to determine the proportion of people who dream in black and white instead of color. Among 319 people over the age of 55, 65 dream in black and white, and among 296 people under the age of 25, 19 dream in black and white. Use a 0.01 significance level to test the claim that the proportion of people over 55 who dream in black and white is greater than the proportion for those under 25. Complete parts (a) through (c) below.arrow_forwardDoes it mean less than 1, at most 1, exactly 1, more than 1, or at least 1?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning