Elementary Statistics Using Excel (6th Edition)
6th Edition
ISBN: 9780134506623
Author: Mario F. Triola
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 7.2, Problem 31BSC
To determine
To find: The number of grade-point averages.
To check: Whether the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these 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:
2. 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…
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.)
Chapter 7 Solutions
Elementary Statistics Using Excel (6th Edition)
Ch. 7.1 - 1. Poll Results in the Media USA Today provided...Ch. 7.1 - 2. Margin of Error For the poll described in...Ch. 7.1 - 3. Notation For the poll described in Exercise 1,...Ch. 7.1 - 4. Confidence Levels Given specific sample data,...Ch. 7.1 - Prob. 5BSCCh. 7.1 - Prob. 6BSCCh. 7.1 - Prob. 7BSCCh. 7.1 - Prob. 8BSCCh. 7.1 - Formats of Confidence Intervals. In Exercises...Ch. 7.1 - Prob. 10BSC
Ch. 7.1 - Prob. 11BSCCh. 7.1 - Prob. 12BSCCh. 7.1 - Constructing and Interpreting Confidence...Ch. 7.1 - Prob. 14BSCCh. 7.1 - Prob. 15BSCCh. 7.1 - Prob. 16BSCCh. 7.1 - Critical Thinking. In Exercises 17–28, use the...Ch. 7.1 - Prob. 18BSCCh. 7.1 - Prob. 19BSCCh. 7.1 - Critical Thinking. In Exercises 17–28, use the...Ch. 7.1 - 21. Touch Therapy When she was 9 years of age,...Ch. 7.1 - Prob. 22BSCCh. 7.1 - Prob. 23BSCCh. 7.1 - Critical Thinking. In Exercises 17–28, use the...Ch. 7.1 - Prob. 25BSCCh. 7.1 - Prob. 26BSCCh. 7.1 - Prob. 27BSCCh. 7.1 - Prob. 28BSCCh. 7.1 - Using Appendix B Data Sets. In Exercises 29 and...Ch. 7.1 - Prob. 30BSCCh. 7.1 - Determining Sample Size. In Exercises 31–38, use...Ch. 7.1 - Determining Sample Size. In Exercises 31–38, use...Ch. 7.1 - Determining Sample Size. In Exercises 31–38, use...Ch. 7.1 - Determining Sample Size. In Exercises 31–38, use...Ch. 7.1 - Prob. 35BSCCh. 7.1 - Prob. 36BSCCh. 7.1 - Prob. 37BSCCh. 7.1 - Prob. 38BSCCh. 7.1 - Prob. 39BBCh. 7.1 - Prob. 40BBCh. 7.1 - Prob. 41BBCh. 7.2 - In Exercises 1–3, refer to the accompanying screen...Ch. 7.2 - Statistical Literacy and Critical Thinking
In...Ch. 7.2 - Prob. 3BSCCh. 7.2 - Prob. 4BSCCh. 7.2 - Prob. 5BSCCh. 7.2 - Prob. 6BSCCh. 7.2 - Prob. 7BSCCh. 7.2 - Prob. 8BSCCh. 7.2 - Prob. 9BSCCh. 7.2 - Prob. 10BSCCh. 7.2 - Prob. 11BSCCh. 7.2 - Prob. 12BSCCh. 7.2 - Prob. 13BSCCh. 7.2 - Prob. 14BSCCh. 7.2 - Prob. 15BSCCh. 7.2 - Confidence Intervals. In Exercises 9–24, construct...Ch. 7.2 - Prob. 17BSCCh. 7.2 - Prob. 18BSCCh. 7.2 - Prob. 19BSCCh. 7.2 - Prob. 20BSCCh. 7.2 - Prob. 21BSCCh. 7.2 - Confidence Intervals. In Exercises 9–24, construct...Ch. 7.2 - Prob. 23BSCCh. 7.2 - Prob. 24BSCCh. 7.2 - Prob. 25BSCCh. 7.2 - In Exercises 25 – 28, use the Appendix B data sets...Ch. 7.2 - In Exercises 25 – 28, use the Appendix B data sets...Ch. 7.2 - Prob. 28BSCCh. 7.2 - Prob. 29BSCCh. 7.2 - Prob. 30BSCCh. 7.2 - Prob. 31BSCCh. 7.2 - Prob. 32BSCCh. 7.2 - Prob. 33BSCCh. 7.2 - Prob. 34BSCCh. 7.2 - Prob. 35BSCCh. 7.2 - Prob. 36BSCCh. 7.2 - Prob. 37BBCh. 7.2 - Prob. 38BBCh. 7.2 - Prob. 39BBCh. 7.3 - Prob. 1BSCCh. 7.3 - Prob. 2BSCCh. 7.3 - Prob. 3BSCCh. 7.3 - 4. Normality Requirement What is different about...Ch. 7.3 - Prob. 5BSCCh. 7.3 - Prob. 6BSCCh. 7.3 - Prob. 7BSCCh. 7.3 - Prob. 8BSCCh. 7.3 - Prob. 9BSCCh. 7.3 - Finding Confidence Intervals. In Exercises 9–16,...Ch. 7.3 - Prob. 11BSCCh. 7.3 - Prob. 12BSCCh. 7.3 - Prob. 13BSCCh. 7.3 - Prob. 14BSCCh. 7.3 - Finding Confidence Intervals. In Exercises 9–16,...Ch. 7.3 - 16. Comparing Waiting Lines
a. The values listed...Ch. 7.3 - Prob. 17BSCCh. 7.3 - Prob. 18BSCCh. 7.3 - Prob. 19BSCCh. 7.3 - Prob. 20BSCCh. 7.3 - Prob. 21BSCCh. 7.3 - Prob. 22BSCCh. 7.3 - Prob. 23BBCh. 7.3 - Prob. 24BBCh. 7.4 - Prob. 1BSCCh. 7.4 - Prob. 2BSCCh. 7.4 - 3. Bootstrap Sample Given the sample data from...Ch. 7.4 - Prob. 4BSCCh. 7.4 - Prob. 5BSCCh. 7.4 - Prob. 6BSCCh. 7.4 - Prob. 7BSCCh. 7.4 - Prob. 8BSCCh. 7.4 - Prob. 9BSCCh. 7.4 - Prob. 10BSCCh. 7.4 - Prob. 11BSCCh. 7.4 - Prob. 12BSCCh. 7.4 - Prob. 17BSCCh. 7.4 - Prob. 18BSCCh. 7.4 - Prob. 19BSCCh. 7.4 - Prob. 20BSCCh. 7.4 - Analysis of Last Digits Weights of respondents...Ch. 7.4 - Analysis of Last Digits Repeat Exercise 21...Ch. 7.4 - Prob. 23BBCh. 7.4 - Prob. 24BBCh. 7 - Prob. 1CQQCh. 7 - Prob. 2CQQCh. 7 - Prob. 3CQQCh. 7 - 4. Loose Change USA Today reported that 40% of...Ch. 7 - 5. Sample Size for Proportion Find the sample size...Ch. 7 - Prob. 6CQQCh. 7 - Prob. 7CQQCh. 7 - Prob. 8CQQCh. 7 - Prob. 9CQQCh. 7 - Prob. 10CQQCh. 7 - Prob. 1RECh. 7 - Prob. 2RECh. 7 - Prob. 3RECh. 7 - Prob. 4RECh. 7 - Prob. 5RECh. 7 - Prob. 6RECh. 7 - Prob. 7RECh. 7 - Prob. 8RECh. 7 - Prob. 9RECh. 7 - Prob. 1CRECh. 7 - Prob. 2CRECh. 7 - Prob. 3CRECh. 7 - Prob. 4CRECh. 7 - Prob. 5CRECh. 7 - Prob. 6CRECh. 7 - Prob. 7CRECh. 7 - Prob. 8CRECh. 7 - Prob. 1EPCh. 7 - Prob. 1FDDCh. 7 - Prob. 2FDDCh. 7 - Prob. 3FDDCh. 7 - Prob. 4FDDCh. 7 - Prob. 5FDD
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 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_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forward
- This 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_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forward
- DATA TABLE VALUES Meal Price ($) 22.78 31.90 33.89 22.77 18.04 23.29 35.28 42.38 36.88 38.55 41.68 25.73 34.19 31.75 25.24 26.32 19.57 36.57 32.97 36.83 30.17 37.29 25.37 24.71 28.79 32.83 43.00 35.23 34.76 33.06 27.73 31.89 38.47 39.42 40.72 43.92 36.51 45.25 33.51 29.17 30.54 26.74 37.93arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forwardSales personnel for Skillings Distributors submit weekly reports listing the customer contacts made during the week. A sample of 65 weekly reports showed a sample mean of 19.5 customer contacts per week. The sample standard deviation was 5.2. Provide 90% and 95% confidence intervals for the population mean number of weekly customer contacts for the sales personnel. 90% Confidence interval, to 2 decimals: ( , ) 95% Confidence interval, to 2 decimals:arrow_forward
- A simple random sample of 40 items resulted in a sample mean of 25. The population standard deviation is 5. a. What is the standard error of the mean (to 2 decimals)? b. At 95% confidence, what is the margin of error (to 2 decimals)?arrow_forwardmean trough level of the population to be 3.7 micrograms/mL. The researcher conducts a study among 93 newly diagnosed arthritis patients and finds the mean trough to be 4.1 micrograms/mL with a standard deviation of 2.4 micrograms/mL. The researcher wants to test at the 5% level of significance if the trough is different than previously reported or not. Z statistics will be used. Complete Step 5 of hypothesis testing: Conclusion. State whether or not you would reject the null hypothesis and why. Also interpret what this means (i.e. is the mean trough different from 3.7 or noarrow_forward30% of all college students major in STEM (Science, Technology, Engineering, and Math). If 48 college students are randomly selected, find the probability thata. Exactly 12 of them major in STEM. b. At most 17 of them major in STEM. c. At least 12 of them major in STEM. d. Between 9 and 13 (including 9 and 13) of them major in STEM.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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