Business Analytics
3rd Edition
ISBN: 9780135231715
Author: Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 2, Problem 4PE
Convert the Store and Regional Sales database to an Excel table. Use the techniques described in Example 2.4 to find:
- the total number of units sold.
- the total number of units sold in the South region.
- the total number of units sold in December.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Fruit prices and the amounts consumed for 2010 and 2018 are shown. Use 2010 as the base.
Fruit
Bananas (pound)
Grapefruit (each)
Apples (pound)
Strawberries (basket)
Oranges (bag)
Fruit
Bananas
Grapefruit
Apples
Strawberries
Oranges
%media:2excel.ext% Click here for the Excel Data File
2010
Price Quantity Price
$0.24
100
$0.34
0.28
0.50
0.34
0.68
1.03
2.42
0.91
1.01
Simple index
Simple aggregate price index
50
85
8
6
Laspeyres price index
2018
a. Determine the simple price indexes. (Round your answers to 2 decimal places.)
Quantity
116
51
85
10
11
b. Determine the simple aggregate price index for the two years. (Round your answer to 2 decimal places.)
c. Determine the Laspeyres price index. (Round your answer to 2 decimal places.)
Please help with (d)
The average monthly residential gas bill for Black Hills Energy customers in Cheyenne, Wyoming is (Wyoming Public Service Commission website). How is the average monthly gas bill for a Cheyenne residence related to the square footage, number of rooms, and age of the residence? The following data show the average monthly gas bill for last year, square footage, number of rooms, and age for typical Cheyenne residences.
Average Monthly Gas
Number of
Bill for Last Year
Age
Square Footage
Rooms
$70.20
16
2537
6
$81.33
2
3437
8
$45.86
27
976
6
$59.21
11
1713
7
$117.88
16
3979
11
$57.78
2
1328
7
$47.01
27
1251
6
$52.89
4
827
5
$32.90
12
645
4
$67.04
29
2849
5
$76.76
1
2392
7
$60.40
26
900
5
$44.07
14
1386
5
$26.68
20
1299
4
$62.70
17
1441
6
$45.37
13
562
4
$38.09
10
2140
4
$45.31
22
908
6
$52.45
24
1568
5
$96.11
27
1140
10…
Chapter 2 Solutions
Business Analytics
Ch. 2 - The Excel file Syringe Samples provides data for...Ch. 2 - Convert the Store and Regional Sales database to...Ch. 2 - Convert the Purchase Orders database to an Excel...Ch. 2 - Prob. 6PECh. 2 - Prob. 8PECh. 2 - In the Excel file Automobile Quality, search for...Ch. 2 - Prob. 10PECh. 2 - Conduct a Pareto analysis for the number of...Ch. 2 - Use Excels filtering capability in the Purchase...Ch. 2 - In the Sales Transactions database, use Excels...
Ch. 2 - Filter the data in the Bicycle Inventory database...Ch. 2 - Use the Excel file Credit Risk Data that was...Ch. 2 - Apply the Advanced Filter to the Credit Risk Data...Ch. 2 - Prob. 17PECh. 2 - For the Bicycle Inventory database, use database...Ch. 2 - For the Bicycle Inventory database, write a...Ch. 2 - The Excel file SP500 provides open, high, low, and...Ch. 2 - In the Purchase Orders database, we need to find...Ch. 2 - An auditor found an expense receipt for 179.24...Ch. 2 - Use PivotTables to find the number of sales...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Stock Market During the week of June 22, 2009, the closing numbers of the Dow Jones Industrial Average each day were: What was the overall change for the week? Was it positive or negative?arrow_forwardThe director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on this information if the company contacts 900 potential donors to donate at the $100 level or below E Click the icon to view the percentages of donors and gift levels. C..... 3 Philanthropist $5,000 11 =B3*C3 4 Producer's Circle $1,000 25 =B4*C4 5 Director's Circle $500 49 =B5 C5 6 Principal $100 8% =B6*C6*$B$9 7 Soloist $50 14% =B7*C7*SB$9 8. 9 Solicitations 900 10 Total Donations =SUM(D2:D7) Enter the values in the model. (Type integers or decimals. Do not round.) B D Average Number of Gifts 1 Gift Level Amount Donations 2 Benefactor $10,000 3 Philanthropist $5,000 11 4 Producer's Circle $1,000 25 5 Director's Circle $500 49 6 Principal $100 8% ns? 7 Soloist $50 14% 8. 9…arrow_forwardA statistics professor kept attendance records and recorded the number of absent students per class. This data is displayed in the following histogram with the frequency of each number of absent students shown above the bars. How many total classes do these data represent?arrow_forward
- Answers for letter d onlyarrow_forwardThe data in the picture contains purchase data for golf purchases. Create a doughnut chart in Excel to compare the purchases by gender each year with the US population. Below the chart, explain what it illustrates.arrow_forwardAnswer using MS Excel. The following table shows the values in General Government Consumption Expenditure (in US) for the Philippines from 2007 to 2016. General government final consumption expenditure includes all government current expenditures for purchases of goods and services (including compensation of employees.) It also includes most expenditures on national defense and security but excludes government military expenditures that are part of government capital formation. (Source: World Bank national accounts data, and OECD National Accounts data files.) Year Consumption Expenditure 2007 $13,867,990,000 2008 $15,384,520,000 2009 $16,598,320,000 2010 $19,403,620,000 2011 $21,744,840,000 2012 $27,117,510,000 2013 $29,468,210,000 2014 $30,054,320,000 2015 $31,993,260,000 2016 $33,926,500,000 Use any statistical tool or program to construct a bar graph, a pie chart, and a line graph. Which…arrow_forward
- Answer ffarrow_forwardThe data were collected from a statistics class. The column head gives the variable, and each of the rows represents a student in the class. Find the frequency, proportion, and percentage of women. Click the icon to view the data table. Stats class data The frequency of women in the class is (Type an integer or a decimal.) Shoe Height Weight Size (inches)(pounds) of Siblings Number College Units Eye Color The proportion of women in the class is Male Age Handedness This Term (Type an integer or a fraction.) 31 Hazel 7.5 65 130 4 12 Right The percentage of women in the class is %. 32 Blue 10.5 69 140 1 9. Left (Round to one decimal place as needed.) 1 30 Brown 7.5 65 175 2 9. Left Right Right Left 1 30 Blue 10 61 150 1 7 1 30 Hazel 11.5 67 125 6. 7 1 30 Blue 9 64 135 9 1 29 Blue 7.5 61 150 2 15 Left Right Right Left 1 21 Brown 12.5 65 185 7 12 1 20 Blue 6. 69 120 1 11 ㅇ 22 Brown 7.5 61 190 8 1 20 Hazel 10.5 65 145 13 Right Print Donearrow_forwardWhich phase in a forensic investigation is likely to be most relevant to Excel? Data analysis Data entry Data preparation Data collectionarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALAlgebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal LittellElementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageMathematics For Machine TechnologyAdvanced MathISBN:9781337798310Author:Peterson, John.Publisher:Cengage Learning,
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY