Business Analytics, Loose-leaf Edition (3rd Edition)
3rd Edition
ISBN: 9780135231692
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 10PE
Construct frequency distributions and histograms using the Excel Histogram tool for the gross sales and gross profit data in the Excel file Sales Data. First let Excel automatically determine the number of bins and bin
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 4 Solutions
Business Analytics, Loose-leaf Edition (3rd Edition)
Ch. 4 - Prob. 1PECh. 4 - Classify each of the data elements in the Sales...Ch. 4 - Identify each of the variables in the Excel file...Ch. 4 - Classify each of the variables in the Excel file...Ch. 4 - Use the COUNTIF function to construct a frequency...Ch. 4 - A community health status survey obtained the...Ch. 4 - Construct frequency distributions and histograms...Ch. 4 - Use the Histogram tool to develop a frequency...Ch. 4 - Prob. 12PECh. 4 - Use a PivotTable to construct a frequency...
Ch. 4 - Prob. 14PECh. 4 - Find the 20thand80th percentiles of home prices in...Ch. 4 - Find the 10thand90th percentiles and the first and...Ch. 4 - Prob. 18PECh. 4 - Find the first, second, and third quartiles for...Ch. 4 - Prob. 20PECh. 4 - Prob. 21PECh. 4 - Find the mean, median, and midrange for the data...Ch. 4 - In the Excel file Facebook Survey, find the mean,...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - In the Excel file Facebook Survey, find the range,...Ch. 4 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - The Excel file Atlanta Airline Data provides...Ch. 4 - Compute the coefficient of variation for each...Ch. 4 - Find 30 days of stock prices for three companies...Ch. 4 - Apply the Descriptive Statistics tool for subsets...Ch. 4 - Use the Descriptive Statistics tool to summarize...Ch. 4 - Prob. 39PECh. 4 - Prob. 42PECh. 4 - Prob. 43PECh. 4 - Prob. 44PECh. 4 - Prob. 45PECh. 4 - In the Excel file Bicycle Inventory, find the...Ch. 4 - Prob. 48PECh. 4 - Prob. 49PECh. 4 - Prob. 50PECh. 4 - Prob. 51PECh. 4 - Prob. 52PECh. 4 - Prob. 55PECh. 4 - Prob. 56PECh. 4 - Prob. 57PECh. 4 - Prob. 58PECh. 4 - Prob. 59PECh. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 61PECh. 4 - Prob. 62PECh. 4 - For the Presidents Inn Guest Database, find the...Ch. 4 - For the Excel file Credit Risk Data, compute the...Ch. 4 - Compute the z-scores for the data in the Excel...Ch. 4 - Prob. 67PECh. 4 - Prob. 68PECh. 4 - Prob. 70PECh. 4 - Prob. 71PECh. 4 - Prob. 73PECh. 4 - Prob. 74PECh. 4 - Prob. 75PE
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
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License