Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 37PE
Construct PivotTables showing the counts of gender versus carrier and type versus usage in the Excel file Cell Phone Survey. What might you conclude from this analysis?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
2. An experiment is set up to test the effectiveness of a new drug for balancing
people's mood. The table below contains the results of the patients before and
after taking the drug. The possible scores are the integers from 0 to 10, where
0 indicates a depressed mood and 10 indicates and elated mood.
Patient Before
After
1
4
4
2
3
3
3
6
4
4
1
2
5
6
5
6
1
3
7
4
7
8
6
9
1
4
10
5
4
Assuming the differences of the observations to be symmetric, but not normally
distributed, investigate the effectiveness of the drug at the 5% significance level.
[4 Marks]
3. (i) Consider the following R code:
wilcox.test(UK Supermarkets $Salary ~ UKSupermarkets $Supermarket)
(a) Which test is being used in this code?
(b) What is the name of the dataset under consideration?
How would be adapt this code if we had ties? What other command
can be used which deals with ties?
(ii) Consider the following R code:
install packages("nortest")
library(nortest)
lillie.test (Differences)
(a) Assuming the appropriate dataset has been imported and attached,
what is wrong with this code?
(b) If this code were to be corrected, what would be determined by run-
ning it?
[3 Marks]
1. (i) Explain the difference in application between the Mann-Whitney U test
and the Wilcoxon Signed-Rank test, i.e. in which scenarios would each test be
used?
(ii) What is the main procedure underlying these nonparametric tests?
[3 Marks]
Chapter 2 Solutions
Business Analytics
Ch. 2 - Explain the difference between a data set and a...Ch. 2 - For the Monthly Product Sales Excel file, use the...Ch. 2 - For the Monthly Product Sales Excel file, use the...Ch. 2 - What does the term filtering mean in the context...Ch. 2 - Convert the Credit Risk database to an Excel...Ch. 2 - Sort the data in the purchase orders database from...Ch. 2 - Prob. 2.4CYUCh. 2 - Prob. 3.1CYUCh. 2 - Prob. 3.2CYUCh. 2 - Prob. 3.3CYU
Ch. 2 - Prob. 4.1CYUCh. 2 - In the Purchase Orders database, what will =...Ch. 2 - Prob. 4.3CYUCh. 2 - Prob. 5.1CYUCh. 2 - Prob. 5.2CYUCh. 2 - Prob. 5.3CYUCh. 2 - Prob. 5.4CYUCh. 2 - Prob. 6.1CYUCh. 2 - Prob. 6.2CYUCh. 2 - Prob. 6.3CYUCh. 2 - The Excel file MBA Motivation and Salary...Ch. 2 - Prob. 2PECh. 2 - The Budget Forecasting database shows estimated...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 - The Excel file Corporate Default Database...Ch. 2 - Open the Excel file Store and Regional Sales...Ch. 2 - In the Excel file Automobile Quality, search for...Ch. 2 - In the Purchase Orders database, conduct a Pareto...Ch. 2 - Conduct a Pareto analysis for the number of...Ch. 2 - Prob. 12PECh. 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 - Prob. 18PECh. 2 - Modify the data in the Base Data worksheet in the...Ch. 2 - Prob. 20PECh. 2 - Figure 2.41 shows the 2016 U.S. federal income tax...Ch. 2 - For the Bicycle Inventory database, write a...Ch. 2 - Prob. 23PECh. 2 - A manager needs to identify some information from...Ch. 2 - The Excel file SP 500 provides open, high, low,...Ch. 2 - Enhance the Sales Transactions database file to...Ch. 2 - Prob. 27PECh. 2 - For this exercise, use the Purchase Orders...Ch. 2 - Use INDEX and MATCH functions to fill in a table...Ch. 2 - Prob. 30PECh. 2 - Prob. 31PECh. 2 - Prob. 32PECh. 2 - Prob. 33PECh. 2 - Prob. 34PECh. 2 - A college graduate who is living in Cincinnati...Ch. 2 - The Excel file Payroll Data provides hourly...Ch. 2 - Construct PivotTables showing the counts of gender...Ch. 2 - Prob. 38PECh. 2 - Prob. 39PECh. 2 - Prob. 40PECh. 2 - Prob. 2.1C
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
- You may need to use the appropriate appendix table or technology to answer this question. You are given the following information obtained from a random sample of 4 observations. 24 48 31 57 You want to determine whether or not the mean of the population from which this sample was taken is significantly different from 49. (Assume the population is normally distributed.) (a) State the null and the alternative hypotheses. (Enter != for ≠ as needed.) H0: Ha: (b) Determine the test statistic. (Round your answer to three decimal places.) (c) Determine the p-value, and at the 5% level of significance, test to determine whether or not the mean of the population is significantly different from 49. Find the p-value. (Round your answer to four decimal places.) p-value = State your conclusion. Reject H0. There is insufficient evidence to conclude that the mean of the population is different from 49.Do not reject H0. There is sufficient evidence to conclude that the…arrow_forward65% of all violent felons in the prison system are repeat offenders. If 43 violent felons are randomly selected, find the probability that a. Exactly 28 of them are repeat offenders. b. At most 28 of them are repeat offenders. c. At least 28 of them are repeat offenders. d. Between 22 and 26 (including 22 and 26) of them are repeat offenders.arrow_forward08:34 ◄ Classroom 07:59 Probs. 5-32/33 D ا. 89 5-34. Determine the horizontal and vertical components of reaction at the pin A and the normal force at the smooth peg B on the member. A 0,4 m 0.4 m Prob. 5-34 F=600 N fr th ar 0. 163586 5-37. The wooden plank resting between the buildings deflects slightly when it supports the 50-kg boy. This deflection causes a triangular distribution of load at its ends. having maximum intensities of w, and wg. Determine w and wg. each measured in N/m. when the boy is standing 3 m from one end as shown. Neglect the mass of the plank. 0.45 m 3 marrow_forward
- Examine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include: Mileage (mpg) Number of Cylinders (cyl) Displacement (disp) Horsepower (hp) Research: Google to understand these variables. Statistical Analysis: Select mpg variable, and perform the following statistical tests. Once you are done with these tests using mpg variable, repeat the same with hp Mean Median First Quartile (Q1) Second Quartile (Q2) Third Quartile (Q3) Fourth Quartile (Q4) 10th Percentile 70th Percentile Skewness Kurtosis Document Your Results: In RStudio: Before running each statistical test, provide a heading in the format shown at the bottom. “# Mean of mileage – Your name’s command” In Microsoft Word: Once you've completed all tests, take a screenshot of your results in RStudio and paste it into a Microsoft Word document. Make sure that snapshots are very clear. You will need multiple snapshots. Also transfer these results to the…arrow_forwardExamine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include: Mileage (mpg) Number of Cylinders (cyl) Displacement (disp) Horsepower (hp) Research: Google to understand these variables. Statistical Analysis: Select mpg variable, and perform the following statistical tests. Once you are done with these tests using mpg variable, repeat the same with hp Mean Median First Quartile (Q1) Second Quartile (Q2) Third Quartile (Q3) Fourth Quartile (Q4) 10th Percentile 70th Percentile Skewness Kurtosis Document Your Results: In RStudio: Before running each statistical test, provide a heading in the format shown at the bottom. “# Mean of mileage – Your name’s command” In Microsoft Word: Once you've completed all tests, take a screenshot of your results in RStudio and paste it into a Microsoft Word document. Make sure that snapshots are very clear. You will need multiple snapshots. Also transfer these results to the…arrow_forwardExamine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include: Mileage (mpg) Number of Cylinders (cyl) Displacement (disp) Horsepower (hp) Research: Google to understand these variables. Statistical Analysis: Select mpg variable, and perform the following statistical tests. Once you are done with these tests using mpg variable, repeat the same with hp Mean Median First Quartile (Q1) Second Quartile (Q2) Third Quartile (Q3) Fourth Quartile (Q4) 10th Percentile 70th Percentile Skewness Kurtosis Document Your Results: In RStudio: Before running each statistical test, provide a heading in the format shown at the bottom. “# Mean of mileage – Your name’s command” In Microsoft Word: Once you've completed all tests, take a screenshot of your results in RStudio and paste it into a Microsoft Word document. Make sure that snapshots are very clear. You will need multiple snapshots. Also transfer these results to the…arrow_forward
- 2 (VaR and ES) Suppose X1 are independent. Prove that ~ Unif[-0.5, 0.5] and X2 VaRa (X1X2) < VaRa(X1) + VaRa (X2). ~ Unif[-0.5, 0.5]arrow_forward8 (Correlation and Diversification) Assume we have two stocks, A and B, show that a particular combination of the two stocks produce a risk-free portfolio when the correlation between the return of A and B is -1.arrow_forward9 (Portfolio allocation) Suppose R₁ and R2 are returns of 2 assets and with expected return and variance respectively r₁ and 72 and variance-covariance σ2, 0%½ and σ12. Find −∞ ≤ w ≤ ∞ such that the portfolio wR₁ + (1 - w) R₂ has the smallest risk.arrow_forward
- 7 (Multivariate random variable) Suppose X, €1, €2, €3 are IID N(0, 1) and Y2 Y₁ = 0.2 0.8X + €1, Y₂ = 0.3 +0.7X+ €2, Y3 = 0.2 + 0.9X + €3. = (In models like this, X is called the common factors of Y₁, Y₂, Y3.) Y = (Y1, Y2, Y3). (a) Find E(Y) and cov(Y). (b) What can you observe from cov(Y). Writearrow_forward1 (VaR and ES) Suppose X ~ f(x) with 1+x, if 0> x > −1 f(x) = 1−x if 1 x > 0 Find VaRo.05 (X) and ES0.05 (X).arrow_forwardJoy is making Christmas gifts. She has 6 1/12 feet of yarn and will need 4 1/4 to complete our project. How much yarn will she have left over compute this solution in two different ways 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
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Propositional Logic, Propositional Variables & Compound Propositions; Author: Neso Academy;https://www.youtube.com/watch?v=Ib5njCwNMdk;License: Standard YouTube License, CC-BY
Propositional Logic - Discrete math; Author: Charles Edeki - Math Computer Science Programming;https://www.youtube.com/watch?v=rL_8y2v1Guw;License: Standard YouTube License, CC-BY
DM-12-Propositional Logic-Basics; Author: GATEBOOK VIDEO LECTURES;https://www.youtube.com/watch?v=pzUBrJLIESU;License: Standard Youtube License
Lecture 1 - Propositional Logic; Author: nptelhrd;https://www.youtube.com/watch?v=xlUFkMKSB3Y;License: Standard YouTube License, CC-BY
MFCS unit-1 || Part:1 || JNTU || Well formed formula || propositional calculus || truth tables; Author: Learn with Smily;https://www.youtube.com/watch?v=XV15Q4mCcHc;License: Standard YouTube License, CC-BY