EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780136880844
Author: Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 2, Problem 39PE
Use PivotTables to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of 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
A psychology researcher conducted a Chi-Square Test of Independence to examine whether there is a relationship between college students’ year in school (Freshman, Sophomore, Junior, Senior) and their preferred coping strategy for academic stress (Problem-Focused, Emotion-Focused, Avoidance). The test yielded the following result:
image.png
Interpret the results of this analysis. In your response, clearly explain:
Whether the result is statistically significant and why.
What this means about the relationship between year in school and coping strategy.
What the researcher should conclude based on these findings.
A school counselor is conducting a research study to examine whether there is a relationship between the number of times teenagers report vaping per week and their academic performance, measured by GPA. The counselor collects data from a sample of high school students. Write the null and alternative hypotheses for this study. Clearly state your hypotheses in terms of the correlation between vaping frequency and academic performance.
EditViewInsertFormatToolsTable
12pt
Paragraph
A smallish urn contains 25 small plastic bunnies – 7 of which are pink and 18 of which are white. 10 bunnies are drawn from the urn at random with replacement, and X is the number of pink bunnies that are drawn.
(a) P(X = 5) ≈
(b) P(X<6) ≈
The Whoville small urn contains 100 marbles – 60 blue and 40 orange. The Grinch sneaks in one night and grabs a simple random sample (without replacement) of 15 marbles.
(a) The probability that the Grinch gets exactly 6 blue marbles is [ Select ] ["≈ 0.054", "≈ 0.043", "≈ 0.061"] .
(b) The probability that the Grinch gets at least 7 blue marbles is [ Select ] ["≈ 0.922", "≈ 0.905", "≈ 0.893"] .
(c) The probability that the Grinch gets between 8 and 12 blue marbles (inclusive) is [ Select ] ["≈ 0.801", "≈ 0.760", "≈ 0.786"] . The Whoville small urn contains 100 marbles – 60 blue and 40 orange. The Grinch sneaks in one night and grabs a simple random sample (without replacement) of 15 marbles.
(a)…
Chapter 2 Solutions
EBK 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
- Suppose an experiment was conducted to compare the mileage(km) per litre obtained by competing brands of petrol I,II,III. Three new Mazda, three new Toyota and three new Nissan cars were available for experimentation. During the experiment the cars would operate under same conditions in order to eliminate the effect of external variables on the distance travelled per litre on the assigned brand of petrol. The data is given as below: Brands of Petrol Mazda Toyota Nissan I 10.6 12.0 11.0 II 9.0 15.0 12.0 III 12.0 17.4 13.0 (a) Test at the 5% level of significance whether there are signi cant differences among the brands of fuels and also among the cars. [10] (b) Compute the standard error for comparing any two fuel brands means. Hence compare, at the 5% level of significance, each of fuel brands II, and III with the standard fuel brand I. [10]arrow_forwardBusiness discussarrow_forwardWhat would you say about a set of quantitative bivariate data whose linear correlation is -1? What would a scatter diagram of the data look like? (5 points)arrow_forward
- Business discussarrow_forwardAnalyze the residuals of a linear regression model and select the best response. yes, the residual plot does not show a curve no, the residual plot shows a curve yes, the residual plot shows a curve no, the residual plot does not show a curve I answered, "No, the residual plot shows a curve." (and this was incorrect). I am not sure why I keep getting these wrong when the answer seems obvious. Please help me understand what the yes and no references in the answer.arrow_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
- Analyze the residuals of a linear regression model and select the best response.Criteria is simple evaluation of possible indications of an exponential model vs. linear model) no, the residual plot does not show a curve yes, the residual plot does not show a curve yes, the residual plot shows a curve no, the residual plot shows a curve I selected: yes, the residual plot shows a curve and it is INCORRECT. Can u help me understand why?arrow_forwardYou 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. please do it step by step on excel 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…arrow_forwardHere is data with as the response variable. x y54.4 19.124.9 99.334.5 9.476.6 0.359.4 4.554.4 0.139.2 56.354 15.773.8 9-156.1 319.2Make a scatter plot of this data. Which point is an outlier? Enter as an ordered pair, e.g., (x,y). (x,y)= Find the regression equation for the data set without the outlier. Enter the equation of the form mx+b rounded to three decimal places. y_wo= Find the regression equation for the data set with the outlier. Enter the equation of the form mx+b rounded to three decimal places. y_w=arrow_forward
- 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. please do it step by step 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…arrow_forwardExercises: Find all the whole number solutions of the congruence equation. 1. 3x 8 mod 11 2. 2x+3= 8 mod 12 3. 3x+12= 7 mod 10 4. 4x+6= 5 mod 8 5. 5x+3= 8 mod 12arrow_forwardScenario 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.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