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 4, Problem 1.31PE
For the Excel file Tablet Computer Sales, find the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Scenario
Sales of products by color follow a peculiar, but predictable, pattern that determines how many units will sell in
any given year. This pattern is shown below
Product Color
1995
1996
1997
Red
28
42
21
1998
23
1999
29
2000
2001
2002
Unit Sales
2003 2004
15
8
4
2
1
2005 2006
discontinued
Green
26
39
20
22
28
14
7
4
2
White
43
65
33
36
45
23
12
Brown
58
87
44
48
60
Yellow
37
56
28
31
Black
28
42
21
Orange
19
29
Purple
Total
28
42
21
49
68
78
95
123
176
181
164
127
24
179
Questions
A) Which color will sell the most units in 2007?
B) Which color will sell the most units combined in the 2007 to 2009 period?
Please show all your analysis, leave formulas in cells, and specify any assumptions you make.
One hundred students were surveyed about their preference between dogs and cats. The following two-way table displays data for the sample of students who responded to the survey.
Preference
Male
Female
TOTAL
Prefers dogs
\[36\]
\[20\]
\[56\]
Prefers cats
\[10\]
\[26\]
\[36\]
No preference
\[2\]
\[6\]
\[8\]
TOTAL
\[48\]
\[52\]
\[100\]
problem 1
Find the probability that a randomly selected student prefers dogs.Enter your answer as a fraction or decimal.
\[P\left(\text{prefers dogs}\right)=\]
Incorrect
Check
Hide explanation
Preference
Male
Female
TOTAL
Prefers dogs
\[\blueD{36}\]
\[\blueD{20}\]
\[\blueE{56}\]
Prefers cats
\[10\]
\[26\]
\[36\]
No preference
\[2\]
\[6\]
\[8\]
TOTAL
\[48\]
\[52\]
\[100\]
There were \[\blueE{56}\] students in the sample who preferred dogs out of \[100\] total students.
Business discuss
Chapter 4 Solutions
Business Analytics
Ch. 4 - Explain the science of statistics.Ch. 4 - What is a metric? How does it differ from a...Ch. 4 - Explain the difference between a discrete and a...Ch. 4 - Describe the four types of measurement scales and...Ch. 4 - What is a frequency distribution?Ch. 4 - Explain how to calculate a relative frequency.Ch. 4 - State how to use Excel for constructing frequency...Ch. 4 - State the features and limitations of the Excel...Ch. 4 - What does an ogive display?Ch. 4 - Prob. 2.6CYU
Ch. 4 - Prob. 3.1CYUCh. 4 - Prob. 3.2CYUCh. 4 - Prob. 3.3CYUCh. 4 - What is a cross-tabulation?Ch. 4 - Prob. 4.2CYUCh. 4 - Explain the difference between a population and a...Ch. 4 - List and explain the common measures of location...Ch. 4 - Prob. 5.3CYUCh. 4 - Prob. 5.4CYUCh. 4 - Prob. 5.5CYUCh. 4 - Prob. 5.6CYUCh. 4 - Prob. 5.7CYUCh. 4 - Prob. 5.8CYUCh. 4 - Prob. 6.1CYUCh. 4 - Use Excel to find the mean and variance for the...Ch. 4 - Prob. 7.1CYUCh. 4 - Prob. 7.2CYUCh. 4 - Prob. 8.1CYUCh. 4 - Prob. 8.2CYUCh. 4 - Prob. 9.1CYUCh. 4 - Prob. 9.2CYUCh. 4 - Prob. 9.3CYUCh. 4 - What rules are typically used to identify...Ch. 4 - Prob. 10.2CYUCh. 4 - Summarize statistical tools that are typically...Ch. 4 - Prob. 11.2CYUCh. 4 - What are the principles of statistical thinking?Ch. 4 - Prob. 12.2CYUCh. 4 - Prob. 12.3CYUCh. 4 - A survey handed out to individuals at a major...Ch. 4 - Prob. 1.2PECh. 4 - Identify each of the variables in the Excel file...Ch. 4 - Prob. 1.4PECh. 4 - Prob. 1.5PECh. 4 - Prob. 1.6PECh. 4 - Prob. 1.7PECh. 4 - Prob. 1.8PECh. 4 - Prob. 1.9PECh. 4 - Prob. 1.10PECh. 4 - Prob. 1.11PECh. 4 - Prob. 1.12PECh. 4 - Use a PivotTable to construct a frequency...Ch. 4 - Prob. 1.14PECh. 4 - Prob. 1.15PECh. 4 - Prob. 1.16PECh. 4 - Prob. 1.17PECh. 4 - Prob. 1.18PECh. 4 - Prob. 1.19PECh. 4 - Prob. 1.20PECh. 4 - Use a PivotTable to construct a cross-tabulation...Ch. 4 - Use PivotTables to construct cross-tabulations for...Ch. 4 - Prob. 1.23PECh. 4 - Prob. 1.24PECh. 4 - Prob. 1.25PECh. 4 - Compute the mean, median, midrange, and mode for...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 - Prob. 1.30PECh. 4 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - The Excel file Atlanta Airline Data provides...Ch. 4 - Prob. 1.33PECh. 4 - Prob. 1.34PECh. 4 - Apply the Descriptive Statistics tool for subsets...Ch. 4 - Use the Descriptive Statistics tool to summarize...Ch. 4 - Prob. 1.38PECh. 4 - The Data worksheet in the Excel file Airport...Ch. 4 - Prob. 1.40PECh. 4 - Prob. 1.41PECh. 4 - Prob. 1.42PECh. 4 - Prob. 1.43PECh. 4 - Prob. 1.44PECh. 4 - Prob. 1.45PECh. 4 - Prob. 1.46PECh. 4 - Prob. 1.47PECh. 4 - Prob. 1.48PECh. 4 - Prob. 1.49PECh. 4 - Prob. 1.50PECh. 4 - Prob. 1.51PECh. 4 - Prob. 1.52PECh. 4 - Prob. 1.53PECh. 4 - In the Excel file Debt and Retirement Savings, use...Ch. 4 - Prob. 1.55PECh. 4 - Prob. 1.56PECh. 4 - Prob. 1.57PECh. 4 - Prob. 1.58PECh. 4 - Prob. 1.59PECh. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 1.61PECh. 4 - The Excel file Beverage Sales lists a sample of...Ch. 4 - For the Presidents Inn Guest Database, find the...Ch. 4 - Prob. 1.64PECh. 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. 1.67PECh. 4 - In the Excel file Weddings, find the mean, median,...Ch. 4 - Use the following approaches to analyze the survey...Ch. 4 - Prob. 1.70PECh. 4 - A producer of computer-aided design software for...Ch. 4 - Prob. 1.72PECh. 4 - Prob. 1.73PECh. 4 - A Midwest pharmaceutical company manufactures...Ch. 4 - Find the mean and variance of a deck of 52 cards,...Ch. 4 - Elizabeth Burke has received several questions...
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 have been hired as an intern to run analyses on the data and report the results back to Sarah; the five questions that Sarah needs you to address are given below. Does there appear to be a positive or negative relationship between price and screen size? Use a scatter plot to examine the relationship. Determine and interpret the correlation coefficient between the two variables. In your interpretation, discuss the direction of the relationship (positive, negative, or zero relationship). Also discuss the strength of the relationship. Estimate the relationship between screen size and price using a simple linear regression model and interpret the estimated coefficients. (In your interpretation, tell the dollar amount by which price will change for each unit of increase in screen size). Include the manufacturer dummy variable (Samsung=1, 0 otherwise) and estimate the relationship between screen size, price and manufacturer dummy as a multiple linear regression model. Interpret the…arrow_forwardDoes there appear to be a positive or negative relationship between price and screen size? Use a scatter plot to examine the relationship. How to take snapshots: if you use a MacBook, press Command+ Shift+4 to take snapshots. If you are using Windows, use the Snipping Tool to take snapshots. Question 1: Determine and interpret the correlation coefficient between the two variables. In your interpretation, discuss the direction of the relationship (positive, negative, or zero relationship). Also discuss the strength of the relationship. Value of correlation coefficient: Direction of the relationship (positive, negative, or zero relationship): Strength of the relationship (strong/moderate/weak): Question 2: Estimate the relationship between screen size and price using a simple linear regression model and interpret the estimated coefficients. In your interpretation, tell the dollar amount by which price will change for each unit of increase in screen size. (The answer for the…arrow_forwardIn this problem, we consider a Brownian motion (W+) t≥0. We consider a stock model (St)t>0 given (under the measure P) by d.St 0.03 St dt + 0.2 St dwt, with So 2. We assume that the interest rate is r = 0.06. The purpose of this problem is to price an option on this stock (which we name cubic put). This option is European-type, with maturity 3 months (i.e. T = 0.25 years), and payoff given by F = (8-5)+ (a) Write the Stochastic Differential Equation satisfied by (St) under the risk-neutral measure Q. (You don't need to prove it, simply give the answer.) (b) Give the price of a regular European put on (St) with maturity 3 months and strike K = 2. (c) Let X = S. Find the Stochastic Differential Equation satisfied by the process (Xt) under the measure Q. (d) Find an explicit expression for X₁ = S3 under measure Q. (e) Using the results above, find the price of the cubic put option mentioned above. (f) Is the price in (e) the same as in question (b)? (Explain why.)arrow_forward
- Problem 4. Margrabe formula and the Greeks (20 pts) In the homework, we determined the Margrabe formula for the price of an option allowing you to swap an x-stock for a y-stock at time T. For stocks with initial values xo, yo, common volatility σ and correlation p, the formula was given by Fo=yo (d+)-x0Þ(d_), where In (±² Ꭲ d+ õ√T and σ = σ√√√2(1 - p). дго (a) We want to determine a "Greek" for ỡ on the option: find a formula for θα (b) Is дго θα positive or negative? (c) We consider a situation in which the correlation p between the two stocks increases: what can you say about the price Fo? (d) Assume that yo< xo and p = 1. What is the price of the option?arrow_forwardWe consider a 4-dimensional stock price model given (under P) by dẴ₁ = µ· Xt dt + йt · ΣdŴt where (W) is an n-dimensional Brownian motion, π = (0.02, 0.01, -0.02, 0.05), 0.2 0 0 0 0.3 0.4 0 0 Σ= -0.1 -4a За 0 0.2 0.4 -0.1 0.2) and a E R. We assume that ☑0 = (1, 1, 1, 1) and that the interest rate on the market is r = 0.02. (a) Give a condition on a that would make stock #3 be the one with largest volatility. (b) Find the diversification coefficient for this portfolio as a function of a. (c) Determine the maximum diversification coefficient d that you could reach by varying the value of a? 2arrow_forwardQuestion 1. Your manager asks you to explain why the Black-Scholes model may be inappro- priate for pricing options in practice. Give one reason that would substantiate this claim? Question 2. We consider stock #1 and stock #2 in the model of Problem 2. Your manager asks you to pick only one of them to invest in based on the model provided. Which one do you choose and why ? Question 3. Let (St) to be an asset modeled by the Black-Scholes SDE. Let Ft be the price at time t of a European put with maturity T and strike price K. Then, the discounted option price process (ert Ft) t20 is a martingale. True or False? (Explain your answer.) Question 4. You are considering pricing an American put option using a Black-Scholes model for the underlying stock. An explicit formula for the price doesn't exist. In just a few words (no more than 2 sentences), explain how you would proceed to price it. Question 5. We model a short rate with a Ho-Lee model drt = ln(1+t) dt +2dWt. Then the interest rate…arrow_forward
- In this problem, we consider a Brownian motion (W+) t≥0. We consider a stock model (St)t>0 given (under the measure P) by d.St 0.03 St dt + 0.2 St dwt, with So 2. We assume that the interest rate is r = 0.06. The purpose of this problem is to price an option on this stock (which we name cubic put). This option is European-type, with maturity 3 months (i.e. T = 0.25 years), and payoff given by F = (8-5)+ (a) Write the Stochastic Differential Equation satisfied by (St) under the risk-neutral measure Q. (You don't need to prove it, simply give the answer.) (b) Give the price of a regular European put on (St) with maturity 3 months and strike K = 2. (c) Let X = S. Find the Stochastic Differential Equation satisfied by the process (Xt) under the measure Q. (d) Find an explicit expression for X₁ = S3 under measure Q. (e) Using the results above, find the price of the cubic put option mentioned above. (f) Is the price in (e) the same as in question (b)? (Explain why.)arrow_forwardThe managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Question content area bottom Part 1 a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costsequals=212495.2212495.2plus+left parenthesis 42.4857 right parenthesis42.485742.4857times×Billable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Part 2 b. Interpret the coefficients of your regression model. Specifically, what does the fixed component of the model mean to the consulting firm? Interpret the fixed term, b 0b0, if appropriate. Choose the correct answer below. A. The value of b 0b0 is the predicted billable hours for an overhead cost of 0 dollars. B. It is not appropriate to interpret b 0b0, because its value…arrow_forwardUsing the accompanying Home Market Value data and associated regression line, Market ValueMarket Valueequals=$28,416+$37.066×Square Feet, compute the errors associated with each observation using the formula e Subscript ieiequals=Upper Y Subscript iYiminus−ModifyingAbove Upper Y with caret Subscript iYi and construct a frequency distribution and histogram. LOADING... Click the icon to view the Home Market Value data. Question content area bottom Part 1 Construct a frequency distribution of the errors, e Subscript iei. (Type whole numbers.) Error Frequency minus−15 comma 00015,000less than< e Subscript iei less than or equals≤minus−10 comma 00010,000 0 minus−10 comma 00010,000less than< e Subscript iei less than or equals≤minus−50005000 5 minus−50005000less than< e Subscript iei less than or equals≤0 21 0less than< e Subscript iei less than or equals≤50005000 9…arrow_forward
- The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c Overhead Costs Billable Hours345000 3000385000 4000410000 5000462000 6000530000 7000545000 8000arrow_forwardUsing the accompanying Home Market Value data and associated regression line, Market ValueMarket Valueequals=$28,416plus+$37.066×Square Feet, compute the errors associated with each observation using the formula e Subscript ieiequals=Upper Y Subscript iYiminus−ModifyingAbove Upper Y with caret Subscript iYi and construct a frequency distribution and histogram. Square Feet Market Value1813 911001916 1043001842 934001814 909001836 1020002030 1085001731 877001852 960001793 893001665 884001852 1009001619 967001690 876002370 1139002373 1131001666 875002122 1161001619 946001729 863001667 871001522 833001484 798001589 814001600 871001484 825001483 787001522 877001703 942001485 820001468 881001519 882001518 885001483 765001522 844001668 909001587 810001782 912001483 812001519 1007001522 872001684 966001581 86200arrow_forwarda. Find the value of A.b. Find pX(x) and py(y).c. Find pX|y(x|y) and py|X(y|x)d. Are x and y independent? Why or why not?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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...
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
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
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