Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
7th Edition
ISBN: 9781337681643
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 3.5, Problem 60E
To determine
(a)
The annual percentage returns for each of the given stock indexes for years 1988 to 2012 using a
To determine
(b)
The sample
To determine
(c)
The sample
To determine
(d)
The similarities and differences between DJIA % returns and Russel 1000 % returns.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
C4 Q6 V1: Randomly collected student data in the dataset STATISTICSSTUDENTSSURVEYFORR contains the columns FEDBEST (preferred Federal party (Conservative, Green, Liberals, or NDP) ) , UNDERGORGRAD (degree being sought (GraduateProfessional, Undergraduate) ) and GENDERIDENTITY (Female or Male or Other). Make a crosstab (contingency) table of the counts for each of the (UNDERGORGRAD, FEDBEST) pairs for ONLY the females. If we randomly select a female student who is pursuing a graduateprofessional degree, what is the probability that she prefers the Federal Liberals. Choose the most correct (closest) answer below.
Question 6 Answer
a.
0.128
b.
0.263
c.
0.744
d.
0.333
Install RStudio: Begin by installing RStudio on your computer. If you haven't done so, please refer to the official RStudio website for download and installation instructions.
Watch the Tutorial Video: Watch the provided video tutorial that explains how to run RStudio. Pay close attention to the steps for opening and managing data files. https://www.youtube.com/watch?v=RhJp6vSZ7z0
Open RStudio: Once RStudio is installed, open the application.
Load the Dataset: In RStudio, open a data file named "mtcars". To do this, type the command mtcars in the script editor and run the command.
Attach the Data: Next, attach the dataset using the command attach(mtcars).
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…
A marketing professor has surveyed the students at her university to better understand attitudes towards PPT usage for higher education. To be able to make inferences to the entire student body, the sample drawn needs to represent the university’s student population on all key characteristics. The table below shows the five key student demographic variables. The professor found the breakdown of the overall student body in the university’s fact book posted online.
A non-parametric chi-square test was used to test the sample demographics against the population percentages shown in the table above. Review the output for the five chi-square tests on the following pages and answer the five questions:
Based on the chi-square test, which sample variables adequately represent the university’s student population and which ones do not? Support your answer by providing the p-value of the chi-square test and explaining what it means.
Using the results from Question 1, make recommendation for…
Chapter 3 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
Ch. 3.1 - Consider a sample with data values of 10, 20, 12,...Ch. 3.1 - Consider a sample with data values of 10, 20, 21,...Ch. 3.1 - Consider the following data and corresponding...Ch. 3.1 - Consider the following data. What is the mean...Ch. 3.1 - Prob. 5ECh. 3.1 - Prob. 6ECh. 3.1 - The average number of minutes Americans commute to...Ch. 3.1 - The WWI Street Journal reported that the median...Ch. 3.1 - Which companies spend the most money on...Ch. 3.1 - Prob. 10E
Ch. 3.1 - According to the National Education Association...Ch. 3.1 - The Big Bang Theory, a situation comedy featuring...Ch. 3.1 - In automobile mileage and gasoline-consumption...Ch. 3.1 - Prob. 14ECh. 3.1 - Martinez Auto Supplies has retail stores located...Ch. 3.1 - The grade point average for college students is...Ch. 3.1 - The following table shows the total return and the...Ch. 3.1 - Prob. 18ECh. 3.1 - Prob. 19ECh. 3.1 - Prob. 20ECh. 3.1 - If an asset declines in value from $5000 to $3500...Ch. 3.1 - The current value of a company is $25 million. If...Ch. 3.2 - Consider a sample with data values of 10, 20, 12,...Ch. 3.2 - Prob. 24ECh. 3.2 - Prob. 25ECh. 3.2 - Data collected by the Oil Price Information...Ch. 3.2 - The results of a search to find the least...Ch. 3.2 - The Australian Open is the first of the four Grand...Ch. 3.2 - Prob. 29ECh. 3.2 - The following data were used to construct the...Ch. 3.2 - Prob. 31ECh. 3.2 - Prob. 32ECh. 3.2 - Scores turned in by an amateur golfer at the...Ch. 3.2 - The following times were recorded by the...Ch. 3.3 - Consider a sample with data values of 10, 20, 12,...Ch. 3.3 - Prob. 36ECh. 3.3 - Prob. 37ECh. 3.3 - Prob. 38ECh. 3.3 - The results of a national survey showed that on...Ch. 3.3 - Prob. 40ECh. 3.3 - Prob. 41ECh. 3.3 - Many families in California are using backyard...Ch. 3.3 - Prob. 43ECh. 3.3 - Prob. 44ECh. 3.3 - The Wall Street Journal reported that Walmart...Ch. 3.4 - Prob. 46ECh. 3.4 - Prob. 47ECh. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 3.4 - Naples, Florida hosts a half-marathon (13.1 -mile...Ch. 3.4 - Annual sales, in millions of dollars, for 21...Ch. 3.4 - Consumer Reports provided overall customer...Ch. 3.4 - Fortune magazine's list of the world's most...Ch. 3.4 - Prob. 54ECh. 3.5 - Five observations taken for two variables follow...Ch. 3.5 - Five observations taken for two variables follow...Ch. 3.5 - Prob. 57ECh. 3.5 - A department of transportation's study on driving...Ch. 3.5 - Over the past 40 years, the percentage of homes in...Ch. 3.5 - Prob. 60ECh. 3.5 - A random sample of 30 colleges from Kiplinger's...Ch. 3 - The average number of times Americans dine out in...Ch. 3 - Prob. 63SECh. 3 - The average waiting time for a patient at an El...Ch. 3 - U.S. companies lose $63.2 billion per year from...Ch. 3 - Prob. 66SECh. 3 - Public transportation and the automobile are two...Ch. 3 - In 2007 the New York Times reported that the...Ch. 3 - Prob. 69SECh. 3 - Travel + Leisure magazine presented its annual...Ch. 3 - The 32 teams in the National Football League (NFL)...Ch. 3 - Does a major league baseball team's record during...Ch. 3 - The days to maturity for a sample of five money...Ch. 3 - Automobiles traveling on a road with a posted...Ch. 3 - The Panama Railroad Company was established in...Ch. 3 - Case Problem 1 Pelican Stores Pelican S to res, a...Ch. 3 - Case Problem 1 Pelican Stores Pelican S to res, a...Ch. 3 - Problem 2Motion Picture Industry The motion...Ch. 3 - Case Problem 2 Motion Picture Industry The motion...Ch. 3 - Case Problem 2 Motion Picture Industry The motion...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 5 African Elephant Populations...Ch. 3 - Case Problem 5 African Elephant Populations...Ch. 3 - Case Problem 5 African Elephant Populations...
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 marketing professor has surveyed the students at her university to better understand attitudes towards PPT usage for higher education. To be able to make inferences to the entire student body, the sample drawn needs to represent the university’s student population on all key characteristics. The table below shows the five key student demographic variables. The professor found the breakdown of the overall student body in the university’s fact book posted online. A non-parametric chi-square test was used to test the sample demographics against the population percentages shown in the table above. Review the output for the five chi-square tests on the following pages and answer the five questions: Based on the chi-square test, which sample variables adequately represent the university’s student population and which ones do not? Support your answer by providing the p-value of the chi-square test and explaining what it means. Using the results from Question 1, make recommendation for…arrow_forwardA retail chain is interested in determining whether a digital video point-of-purchase (POP) display would stimulate higher sales for a brand advertised compared to the standard cardboard point-of-purchase display. To test this, a one-shot static group design experiment was conducted over a four-week period in 100 different stores. Fifty stores were randomly assigned to the control treatment (standard display) and the other 50 stores were randomly assigned to the experimental treatment (digital display). Compare the sales of the control group (standard POP) to the experimental group (digital POP). What were the average sales for the standard POP display (control group)? What were the sales for the digital display (experimental group)? What is the (mean) difference in sales between the experimental group and control group? List the null hypothesis being tested. Do you reject or retain the null hypothesis based on the results of the independent t-test? Was the difference between the…arrow_forwardWhat were the average sales for the four weeks prior to the experiment? What were the sales during the four weeks when the stores used the digital display? What is the mean difference in sales between the experimental and regular POP time periods? State the null hypothesis being tested by the paired sample t-test. Do you reject or retain the null hypothesis? At a 95% significance level, was the difference significant? Explain why or why not using the results from the paired sample t-test. Should the manager of the retail chain install new digital displays in each store? Justify your answer.arrow_forward
- A retail chain is interested in determining whether a digital video point-of-purchase (POP) display would stimulate higher sales for a brand advertised compared to the standard cardboard point-of-purchase display. To test this, a one-shot static group design experiment was conducted over a four-week period in 100 different stores. Fifty stores were randomly assigned to the control treatment (standard display) and the other 50 stores were randomly assigned to the experimental treatment (digital display). Compare the sales of the control group (standard POP) to the experimental group (digital POP). What were the average sales for the standard POP display (control group)? What were the sales for the digital display (experimental group)? What is the (mean) difference in sales between the experimental group and control group? List the null hypothesis being tested. Do you reject or retain the null hypothesis based on the results of the independent t-test? Was the difference between the…arrow_forwardQuestion 4 An article in Quality Progress (May 2011, pp. 42-48) describes the use of factorial experiments to improve a silver powder production process. This product is used in conductive pastes to manufacture a wide variety of products ranging from silicon wafers to elastic membrane switches. Powder density (g/cm²) and surface area (cm/g) are the two critical characteristics of this product. The experiments involved three factors: reaction temperature, ammonium percentage, stirring rate. Each of these factors had two levels, and the design was replicated twice. The design is shown in Table 3. A222222222222233 Stir Rate (RPM) Ammonium (%) Table 3: Silver Powder Experiment from Exercise 13.23 Temperature (°C) Density Surface Area 100 8 14.68 0.40 100 8 15.18 0.43 30 100 8 15.12 0.42 30 100 17.48 0.41 150 7.54 0.69 150 8 6.66 0.67 30 150 8 12.46 0.52 30 150 8 12.62 0.36 100 40 10.95 0.58 100 40 17.68 0.43 30 100 40 12.65 0.57 30 100 40 15.96 0.54 150 40 8.03 0.68 150 40 8.84 0.75 30 150…arrow_forward- + ++ Table 2: Crack Experiment for Exercise 2 A B C D Treatment Combination (1) Replicate I II 7.037 6.376 14.707 15.219 |++++ 1 བྱ॰༤༠སྦྱོ སྦྱོཋཏྟཱུ a b ab 11.635 12.089 17.273 17.815 с ас 10.403 10.151 4.368 4.098 bc abc 9.360 9.253 13.440 12.923 d 8.561 8.951 ad 16.867 17.052 bd 13.876 13.658 abd 19.824 19.639 cd 11.846 12.337 acd 6.125 5.904 bcd 11.190 10.935 abcd 15.653 15.053 Question 3 Continuation of Exercise 2. One of the variables in the experiment described in Exercise 2, heat treatment method (C), is a categorical variable. Assume that the remaining factors are continuous. (a) Write two regression models for predicting crack length, one for each level of the heat treatment method variable. What differences, if any, do you notice in these two equations? (b) Generate appropriate response surface contour plots for the two regression models in part (a). (c) What set of conditions would you recommend for the factors A, B, and D if you use heat treatment method C = +? (d) Repeat…arrow_forward
- Question 2 A nickel-titanium alloy is used to make components for jet turbine aircraft engines. Cracking is a potentially serious problem in the final part because it can lead to nonrecoverable failure. A test is run at the parts producer to determine the effect of four factors on cracks. The four factors are: pouring temperature (A), titanium content (B), heat treatment method (C), amount of grain refiner used (D). Two replicates of a 24 design are run, and the length of crack (in mm x10-2) induced in a sample coupon subjected to a standard test is measured. The data are shown in Table 2. 1 (a) Estimate the factor effects. Which factor effects appear to be large? (b) Conduct an analysis of variance. Do any of the factors affect cracking? Use a = 0.05. (c) Write down a regression model that can be used to predict crack length as a function of the significant main effects and interactions you have identified in part (b). (d) Analyze the residuals from this experiment. (e) Is there an…arrow_forwardA 24-1 design has been used to investigate the effect of four factors on the resistivity of a silicon wafer. The data from this experiment are shown in Table 4. Table 4: Resistivity Experiment for Exercise 5 Run A B с D Resistivity 1 23 2 3 4 5 6 7 8 9 10 11 12 I+I+I+I+Oooo 0 0 ||++TI++o000 33.2 4.6 31.2 9.6 40.6 162.4 39.4 158.6 63.4 62.6 58.7 0 0 60.9 3 (a) Estimate the factor effects. Plot the effect estimates on a normal probability scale. (b) Identify a tentative model for this process. Fit the model and test for curvature. (c) Plot the residuals from the model in part (b) versus the predicted resistivity. Is there any indication on this plot of model inadequacy? (d) Construct a normal probability plot of the residuals. Is there any reason to doubt the validity of the normality assumption?arrow_forwardStem1: 1,4 Stem 2: 2,4,8 Stem3: 2,4 Stem4: 0,1,6,8 Stem5: 0,1,2,3,9 Stem 6: 2,2 What’s the Min,Q1, Med,Q3,Max?arrow_forward
- Are the t-statistics here greater than 1.96? What do you conclude? colgPA= 1.39+0.412 hsGPA (.33) (0.094) Find the P valuearrow_forwardA poll before the elections showed that in a given sample 79% of people vote for candidate C. How many people should be interviewed so that the pollsters can be 99% sure that from 75% to 83% of the population will vote for candidate C? Round your answer to the whole number.arrow_forwardSuppose a random sample of 459 married couples found that 307 had two or more personality preferences in common. In another random sample of 471 married couples, it was found that only 31 had no preferences in common. Let p1 be the population proportion of all married couples who have two or more personality preferences in common. Let p2 be the population proportion of all married couples who have no personality preferences in common. Find a95% confidence interval for . Round your answer to three decimal places.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
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
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