Business Analytics (2nd Edition)
2nd Edition
ISBN: 9780321997821
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 3, Problem 37PE
Use PivotTables to find the number of sales transactions by product and region, total amount of revenue by region, and total revenue by region and product in the Sales Transactions database.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Question 3
The following stem-and-leaf displays the weekly salary of employees at this firm.
Stem-and-Leaf Display
Leaf Unit = 10.0
N=x
5
3 00123
12 4 0125888
(y)
5 11234456777
z
6 13568
5
7 154
2
8 46
i.
Determine the value of x, y and z.
[3]
ii. What is the value of the median?
[2]
iii.
Find the mode of this data set.
iv.
Calculate the range
[1]
[2]
Let Y be a continuous RV with PDF
otherwise
Find the CDF, Fry), of Y .
Find an expression for pth, p € (0, 1), quantile of the distribution.
Find E(Y) and V(Y).
Find E(-2Y + 1) and V(-3Y - 2).
Find E(Y3).
Let X be a continuous RV with CDF
Find P(X < 0), P(-1 < X < 1) and P(0.5 < X).
Based on your answers to the above questions, what is the median of the distribu-tion? Why
Find the PDF, fx (x), of X.
Chapter 3 Solutions
Business Analytics (2nd Edition)
Ch. 3 - Create a line chart for the closing prices for all...Ch. 3 - Create a pie chart showing the breakdown of...Ch. 3 - The Excel tile Facebook Survey provides data...Ch. 3 - A national homebuilder builds single-family homes...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 - 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 - Convert the Store and Regional Sales database to...Ch. 3 - Prob. 14PECh. 3 - Prob. 15PECh. 3 - Prob. 16PECh. 3 - Prob. 17PECh. 3 - In the Purchase Orders database, conduct a Pareto...Ch. 3 - Use Excels filtering capability to (1) extract all...Ch. 3 - Prob. 20PECh. 3 - The Excel file Credit Risk Date Provides...Ch. 3 - Prob. 22PECh. 3 - Prob. 23PECh. 3 - A community health-status survey obtained the...Ch. 3 - Prob. 25PECh. 3 - Prob. 26PECh. 3 - Prob. 27PECh. 3 - Prob. 28PECh. 3 - Prob. 29PECh. 3 - Prob. 30PECh. 3 - Find the 10th and 90th percentiles and 1st, 2nd,...Ch. 3 - Construct cross-tabulations of Gender versus...Ch. 3 - Use PivotTables to construct a cross-tabulation...Ch. 3 - Use PivotTables to construct a cross-tabulation...Ch. 3 - Create a PivotTable to find the average amount of...Ch. 3 - Use PivotTables to find the number of loans by...Ch. 3 - Use PivotTables to find the number of sales...Ch. 3 - Create a PivotTable for the data in the Excel file...Ch. 3 - The Excel File Rins Gym provides sample data on...Ch. 3 - Create useful dashboards for each of the following...Ch. 3 - A marketing researcher surveyed 92 individuals,...
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
- A survey of 581 citizens found that 313 of them favor a new bill introduced by the city. We want to find a 95% confidence interval for the true proportion of the population who favor the bill. What is the lower limit of the interval? Enter the result as a decimal rounded to 3 decimal digits. Your Answer:arrow_forwardLet X be a continuous RV with PDF where a > 0 and 0 > 0 are parameters. verify that f-∞ /x (x)dx = 1. Find the CDF, Fx (7), of X.arrow_forward6. [20] Let X be a continuous RV with PDF 2(1), 1≤x≤2 fx(x) = 0, otherwisearrow_forward
- A survey of 581 citizens found that 313 of them favor a new bill introduced by the city. We want to find a 95% confidence interval for the true proportion of the population who favor the bill. What is the lower limit of the interval? Enter the result as a decimal rounded to 3 decimal digits. Your Answer:arrow_forwardA survey of 581 citizens found that 313 of them favor a new bill introduced by the city. We want to find a 95% confidence interval for the true proportion of the population who favor the bill. What is the lower limit of the interval? Enter the result as a decimal rounded to 3 decimal digits. Your Answer:arrow_forward2. The SMSA data consisting of 141 observations on 10 variables is fitted by the model below: 1 y = Bo+B1x4 + ẞ2x6 + ẞ3x8 + √1X4X8 + V2X6X8 + €. See Question 2, Tutorial 3 for the meaning of the variables in the above model. The following results are obtained: Estimate Std. Error t value Pr(>|t|) (Intercept) 1.302e+03 4.320e+02 3.015 0.00307 x4 x6 x8 x4:x8 x6:x8 -1.442e+02 2.056e+01 -7.013 1.02e-10 6.340e-01 6.099e+00 0.104 0.91737 -9.455e-02 5.802e-02 -1.630 0.10550 2.882e-02 2.589e-03 11.132 1.673e-03 7.215e-04 2.319 F) x4 1 3486722 3486722 17.9286 4.214e-05 x6 1 14595537 x8 x4:x8 x6:x8 1 132.4836 < 2.2e-16 1045693 194478 5.3769 0.02191 1 1198603043 1198603043 6163.1900 < 2.2e-16 1 25765100 25765100 1045693 Residuals 135 26254490 Estimated variance matrix (Intercept) x4 x6 x8 x4:x8 x6:x8 (Intercept) x4 x6 x8 x4:x8 x6:x8 0.18875694 1.866030e+05 -5.931735e+03 -2.322825e+03 -16.25142055 0.57188953 -5.931735e+03 4.228816e+02 3.160915e+01 0.61621781 -0.03608028 -0.00445013 -2.322825e+03…arrow_forward
- In some applications the distribution of a discrete RV, X resembles the Poisson distribution except that 0 is not a possible value of X. Consider such a RV with PMF where 1 > 0 is a parameter, and c is a constant. (a) Find the expression of c in terms of 1. (b) Find E(X). (Hint: You can use the fact that, if Y ~ Poisson(1), the E(Y) = 1.)arrow_forwardSuppose that X ~Bin(n,p). Show that E[(1 - p)] = (1-p²)".arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forward
- I need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forwardThis exercise is based on the following data on four bodybuilding supplements. (Figures shown correspond to a single serving.) Creatine(grams) L-Glutamine(grams) BCAAs(grams) Cost($) Xtend(SciVation) 0 2.5 7 1.00 Gainz(MP Hardcore) 2 3 6 1.10 Strongevity(Bill Phillips) 2.5 1 0 1.20 Muscle Physique(EAS) 2 2 0 1.00 Your personal trainer suggests that you supplement with at least 10 grams of creatine, 39 grams of L-glutamine, and 90 grams of BCAAs each week. You are thinking of combining Xtend and Gainz to provide you with the required nutrients. How many servings of each should you combine to obtain a week's supply that meets your trainer's specifications at the least cost? (If an answer does not exist, enter DNE.) servings of xtend servings of gainzarrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Elementary Geometry for College StudentsGeometryISBN:9781285195698Author:Daniel C. Alexander, Geralyn M. KoeberleinPublisher:Cengage Learning
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY