ELEMENTARY STATISTICS USING EXCEL
7th Edition
ISBN: 9780136921721
Author: Triola
Publisher: RENT PEARS
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 1CQQ
To determine
To sketch: The shape of the distribution of the bone density test scores.
Expert Solution & Answer
Explanation of Solution
Given information:
It is given that the bone density test scores follow the
The normal distribution is a bell-shaped distribution. The
Graph:
First draw a horizontal axis and mark it from -3 to 3. Then draw a bell-shape curve from -3 to 3 and put the value 0 at the center.
The obtained shape of the distribution of the given scores is given below:
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Please help me on this following statistics questionDrop down options for (g) are: (be rejected/not be rejected) & (on average, significantly better/on average, not significantly better)CSV DATA:"","New_Therapy","Standard_Therapy""1","38.6",47.7"2","50.4",49.3"3","49.8",65"4","46.4",42.9"5","45.9",63.2"6","53.5",47.1"7","56.5",66.5"8","46",47.6"9","48.6",66.9"10","44.8",48"11","51",46.1"12","42.8",54.5"13","45.8",50.7"14","41",48.8"15","50.6",62.2"16","39.6",53.9"17","50.1",54.1"18","49",70.1"19","50.2",45.5"20","48.6",48.6"21","45",61.1"22","49.6",53.6"23","38.5",49"24","43.3",53.1"25","43.5",43.6"26","49",59.3"27","48.2",53.5"28","",53"29","",49.4"30","",60.7
Please help me answer this following question on statistics
The CSV data is below:
"","cafe","library"
"A",85,85
"B",64,61
"C",180,179
"D",136,135
"E",152,152
"F",174,169
"G",145,145
"H",87,86
"I",121,121
"J",149,146
"K",140,136
"L",159,159
"M",98,96
"N",130,130
"O",56,52
"P",140,141
"Q",76,78
"R",150,148
"S",133,132
"T",125,122
"U",123,122
"V",85,84
"W",84,85
"X",94,96
"Y",156,154
(a) Based on the above data structure, we should use a (2-sample T test (pooled variance)/Paired T (Matched Pairs) Test/2-sample T test (unequal variance)/Leven's Test.)
(c) Carry out the appropriate statistical test and find the Test Statistic and P-value.
Test Statistic= (use three decimals)
Complete the interpretation and compute the P−value.
Assuming H0 is (false/uncertain/true), the probability of (observing stronger evidence to support the rejecting the/failing to reject the/observing stronger evidence against the) null hypothesis is ___ (use three decimals).
(d) Based on these samples, at the 5% level…
I need help on filling out this following table for statistics. Please help me find the chi squared value as well It has been suggusted that the highest priority of retirees is travel. Thus, a study was conducted to investigate the differences in the length of stay of a trip for pre- and post-retirees. A sample of 714 travelers were asked how long they stayed on a typical trip. The observed results of the study are found below. You may round all answers for this problem to the nearest hundredth. To import data to R, copy and paste the R codes below number=c(rep("4-7",421),rep("8-13",154),rep("14-21",88),rep("22_or_more",51)) retirement=c(rep("pre-retirement",248),rep("post-retirement",173),rep("pre-retirement",79),rep("post-retirement",75),rep("pre-retirement",36),rep("post- retirement",52),rep("pre-retirement",11),rep("post-retirement",40)) data=data.frame(number,retirement) table(data) With this information, construct a table of estimated expected values. Use two digits after the…
Chapter 6 Solutions
ELEMENTARY STATISTICS USING EXCEL
Ch. 6.1 - 1. Normal Distribution What’s wrong with the...Ch. 6.1 - Prob. 2BSCCh. 6.1 - Prob. 3BSCCh. 6.1 - Prob. 4BSCCh. 6.1 - Continuous Uniform Distribution. In Exercises 5–8,...Ch. 6.1 - Continuous Uniform Distribution. In Exercises 5–8,...Ch. 6.1 - Prob. 7BSCCh. 6.1 - Prob. 8BSCCh. 6.1 - Standard Normal Distribution. In Exercises 9–12,...Ch. 6.1 - Standard Normal Distribution. In Exercises 9–12,...
Ch. 6.1 - Standard Normal Distribution. In Exercises 9–12,...Ch. 6.1 - Standard Normal Distribution. In Exercises 9–12,...Ch. 6.1 - Standard Normal Distribution. In Exercises 13–16,...Ch. 6.1 - Standard Normal Distribution. In Exercises 13–16,...Ch. 6.1 - Standard Normal Distribution. In Exercises 13–16,...Ch. 6.1 - Standard Normal Distribution. In Exercises 13–16,...Ch. 6.1 - Prob. 17BSCCh. 6.1 - Prob. 18BSCCh. 6.1 - Prob. 19BSCCh. 6.1 - Prob. 20BSCCh. 6.1 - Prob. 21BSCCh. 6.1 - Prob. 22BSCCh. 6.1 - Prob. 23BSCCh. 6.1 - Prob. 24BSCCh. 6.1 - Prob. 25BSCCh. 6.1 - Prob. 26BSCCh. 6.1 - Prob. 27BSCCh. 6.1 - Prob. 28BSCCh. 6.1 - Prob. 29BSCCh. 6.1 - Prob. 30BSCCh. 6.1 - Prob. 31BSCCh. 6.1 - Prob. 32BSCCh. 6.1 - Prob. 33BSCCh. 6.1 - Prob. 34BSCCh. 6.1 - Prob. 35BSCCh. 6.1 - Prob. 36BSCCh. 6.1 - Finding Bone Density Scores. In Exercises 37–40...Ch. 6.1 - Prob. 38BSCCh. 6.1 - Prob. 39BSCCh. 6.1 - Prob. 40BSCCh. 6.1 - Prob. 41BSCCh. 6.1 - Prob. 42BSCCh. 6.1 - Prob. 43BSCCh. 6.1 - Prob. 44BSCCh. 6.1 - Prob. 45BSCCh. 6.1 - Prob. 46BSCCh. 6.1 - Prob. 47BSCCh. 6.1 - Prob. 48BSCCh. 6.1 - Prob. 49BBCh. 6.1 - Prob. 50BBCh. 6.2 - Prob. 1BSCCh. 6.2 - Prob. 2BSCCh. 6.2 - Prob. 3BSCCh. 6.2 - Prob. 4BSCCh. 6.2 - IQ Scores. In Exercises 5–8, find the area of the...Ch. 6.2 - IQ Scores. In Exercises 5–8, find the area of the...Ch. 6.2 - Prob. 7BSCCh. 6.2 - IQ Scores. In Exercises 5–8, find the area of the...Ch. 6.2 - IQ Scores. In Exercises 9–12, find the indicated...Ch. 6.2 - IQ Scores. In Exercises 9–12, find the indicated...Ch. 6.2 - Prob. 11BSCCh. 6.2 - Prob. 12BSCCh. 6.2 - Prob. 13BSCCh. 6.2 - Prob. 14BSCCh. 6.2 - Prob. 15BSCCh. 6.2 - Prob. 16BSCCh. 6.2 - Prob. 17BSCCh. 6.2 - Prob. 18BSCCh. 6.2 - Prob. 19BSCCh. 6.2 - Prob. 20BSCCh. 6.2 - Prob. 21BSCCh. 6.2 - Prob. 22BSCCh. 6.2 - Prob. 23BSCCh. 6.2 - Prob. 24BSCCh. 6.2 - Prob. 25BSCCh. 6.2 - In Exercises 21–24, use these parameters (based on...Ch. 6.2 - In Exercises 21–24, use these parameters (based on...Ch. 6.2 - Prob. 28BSCCh. 6.2 - Prob. 29BSCCh. 6.2 - Prob. 30BSCCh. 6.2 - Prob. 31BSCCh. 6.2 - Prob. 32BSCCh. 6.2 - Prob. 33BSCCh. 6.2 - Prob. 34BSCCh. 6.2 - Prob. 35BSCCh. 6.2 - Prob. 36BSCCh. 6.2 - Prob. 37BBCh. 6.2 - Prob. 38BBCh. 6.3 - Prob. 1BSCCh. 6.3 - Prob. 2BSCCh. 6.3 - Prob. 3BSCCh. 6.3 - Prob. 4BSCCh. 6.3 - Prob. 5BSCCh. 6.3 - Prob. 6BSCCh. 6.3 - Prob. 7BSCCh. 6.3 - Prob. 8BSCCh. 6.3 - Prob. 9BSCCh. 6.3 - In Exercises 7–10, use the same population of {4,...Ch. 6.3 - Prob. 11BSCCh. 6.3 - Prob. 12BSCCh. 6.3 - Prob. 13BSCCh. 6.3 - Prob. 14BSCCh. 6.3 - Prob. 15BSCCh. 6.3 - Prob. 16BSCCh. 6.3 - Prob. 17BSCCh. 6.3 - Prob. 18BSCCh. 6.3 - Prob. 19BBCh. 6.3 - Prob. 20BBCh. 6.4 - Prob. 1BSCCh. 6.4 - Prob. 2BSCCh. 6.4 - Prob. 3BSCCh. 6.4 - Prob. 4BSCCh. 6.4 - Prob. 5BSCCh. 6.4 - Prob. 6BSCCh. 6.4 - Prob. 7BSCCh. 6.4 - Prob. 8BSCCh. 6.4 - Prob. 9BSCCh. 6.4 - Prob. 10BSCCh. 6.4 - Prob. 11BSCCh. 6.4 - Prob. 12BSCCh. 6.4 - Prob. 13BSCCh. 6.4 - Prob. 14BSCCh. 6.4 - Prob. 15BSCCh. 6.4 - Prob. 16BSCCh. 6.4 - Prob. 17BSCCh. 6.4 - Prob. 18BSCCh. 6.4 - Prob. 19BSCCh. 6.4 - Prob. 20BBCh. 6.5 - Prob. 1BSCCh. 6.5 - Prob. 2BSCCh. 6.5 - Prob. 3BSCCh. 6.5 - Prob. 4BSCCh. 6.5 - Prob. 5BSCCh. 6.5 - Prob. 6BSCCh. 6.5 - Prob. 7BSCCh. 6.5 - Prob. 8BSCCh. 6.5 - Prob. 9BSCCh. 6.5 - Prob. 10BSCCh. 6.5 - Prob. 11BSCCh. 6.5 - Prob. 12BSCCh. 6.5 - Prob. 13BSCCh. 6.5 - Prob. 14BSCCh. 6.5 - Prob. 15BSCCh. 6.5 - Prob. 16BSCCh. 6.5 - Prob. 17BSCCh. 6.5 - Prob. 18BSCCh. 6.5 - Prob. 19BSCCh. 6.5 - Prob. 20BSCCh. 6.5 - Prob. 21BBCh. 6.5 - Prob. 22BBCh. 6 - Prob. 1CQQCh. 6 - Prob. 2CQQCh. 6 - Prob. 3CQQCh. 6 - Prob. 4CQQCh. 6 - Prob. 5CQQCh. 6 - Prob. 6CQQCh. 6 - Prob. 7CQQCh. 6 - Prob. 8CQQCh. 6 - Prob. 9CQQCh. 6 - Prob. 10CQQCh. 6 - Prob. 1RECh. 6 - Prob. 2RECh. 6 - Prob. 3RECh. 6 - Prob. 4RECh. 6 - Prob. 5RECh. 6 - Prob. 6RECh. 6 - Prob. 7RECh. 6 - Prob. 8RECh. 6 - Prob. 9RECh. 6 - Prob. 10RECh. 6 - Prob. 1CRECh. 6 - Prob. 2CRECh. 6 - Prob. 3CRECh. 6 - Prob. 4CRECh. 6 - Prob. 5CRECh. 6 - Prob. 1FDD
Knowledge Booster
Similar questions
- The purpose of this problem is to solve the Black-Scholes PDE with analytical techniques, which will lead us back to the Black-Scholes formula. The technique is very similar to the one used with the Feynman-Kac formula back in MATH 467. Let's consider the PDE given by with terminal condition f(T,x) af + Ət 1 02 ર .2მ2 f af მ2 +rx მე - rf = 0, = (x-K)+. The solution f(t, x) corresponds to the price of a call option (given the initial condition) at time t if the stock price is x. (a) The first two things that prevent us from solving this PDE directly are (i) the fact that we have a terminal condition, instead of an initial condition; (ii) the terms in front of the derivatives are not constant. To address these, we use the transformation g(t, x) = ƒ(T − t,e³), equivalent to f(t, x) = g(T-t, log(x)). Under this condition, determine the PDE and the initial condition satisfied by g. (b) Now, the PDE obtained in (a) should have an initial condition and constant coeffi- cients, but it still…arrow_forwardPlease help me answer question b and c for this problem.A student project involved collecting data to see if there was a difference in the amount of time one had to wait at the drive-thru between two fast food restaurants, A and B. She randomly selected 30 cars at fast food restaurant A and 30 cars at fast food restaurant B. For each car chosen, she recorded how much time passed from the placement of the order to receiving their food at the pick-up window. The data is given in the table below measured in Seconds. Use α=0.05.CSV…arrow_forwardPlease help me with the following statistics problem A long-distance runner wants to compare the durability of two running shoe brands: Brand A and Brand B. Instead of testing them separately, 15 runners simultaneously wear Brand A on the left foot and Brand B on the right foot during training runs. The runner continues training as usual and tracks how many kilometers each shoe lasts before showing significant wear (e.g., loss of cushioning, outsole damage). Since both shoes experience the same runner, terrain, and conditions, any lifespan difference can be attributed to the shoe brand rather than external factors. Test whether Brand A running shoes have a significantly shorter lifespan than Brand B when worn under the same conditions by the same runner. CSV: "","A","B" "A",197,193 "B",230,229 "C",179,180 "D",206,205 "E",182,180 "F",141,142 "G",207,207 "H",116,112 "I",78,79 "J",0,0 "K",213,212 "L",86,83 "M",181,181 "N",85,79 "O",73,71 The…arrow_forward
- An article appeared in the Journal of Gambling Issues, in which the authors looked at random samples of Ontario residents who (i) have not completed some form of post-secondary education and (ii) have completed some form of post-secondary education. A code of 0 indicates the person does not have a gambling problem, a code of 1 indicates the person does have a gambling problem. The data is found in the accompanying data file. Download.csv file To count the frequencies of 0 and 1 in each sample, use the table(your_dataset_name$ column's name) function. Make sure to replace "your_dataset_name" with the actual name of your data file and specify the correct column name. For example: table(file60c5d1286c735$ CompletedPSEducation) Let PNOPS represent the proportion of persons not completing some form of post-secondary education who have a gambling problem, and PPs be the proportion of persons having completed post-secondary education who have a gambling problem. (a) Find a 92% confidence…arrow_forwardWe consider a (European) call option on a stock with expiration in 3 months and strike price $10. The annual interest rate on the market is r = 4%. The current price of the stock is $10 and we assume that the stock follows a geometric Brownian motion (Black-Scholes) model with parameters = 6% and σ = 0.2. (a) Determine the price Fo of this option at time t = : 0 (today). (b) Using the formulas provided in the lecture videos, calculate the value of each of the Greeks for this option. Namely, calculate A, T, v, О, p. (c) Find a formula for the change of the option price with respect to a change in the af (St, t) Әк strike price. In other words, determine (d) For each of the suggested modifications below, use an approximation to determine the change in the price of the option above without actually recalculating the price. For each one, provide an intuitive argument to explain why the price increases or decreases. (i) The rate of return μ decreases to 5%. (ii) The interest rate r…arrow_forwardA box containing 24 seemly identical resistors has just been received. However,unbeknownst, 4 of these resistors are defective. a. Five resistors are randomly selected from this box without replacement (oncemoved from the box it is not returned to the box), what is the probability that oneor more of the defective resistors is among those selected? b. Five resistors are randomly selected from this box with replacement (after theresistor is removed and checked, it is returned to the box prior to the nextselection (hence the same resistor can be selected more than once)), what is theprobability that one or more of the defective resistors is among those selected?arrow_forward
- Business Discussarrow_forwardTriola statistics Readers who prefer printed books Readers who prefer e-booksarrow_forwardThe following is a list of data on the duration of a sample of 200 outbreaks, in hours. 107 73 68 97 76 79 94 59 98 57 54 65 71 70 84 88 62 82 61 79 98 66 62 79 86 68 74 61 62 116 65 88 64 79 78 74 92 75 5289 85 28 73 80 68 78 89 72 78 88 77 103 88 63 68 90 62 89 71 71 74 222 R 82 79 70 ST☑ 65 98 77 86 58 69 88 81 74 70 65 81 75 81 78 90 78 96 75 KRRE F S 62 94 62 79 83 93 135 71 85 84 83 63 61 65 83 70 70 81 77 72 84 33 62 92 65 67 59 58 66 66 94 77 63 71 101 78 43 78 66 75 68 76 59 67 61 71 64 76 72 77 74 65 82 86 66 86 68 85 27% 96 72 77 60 67 87 83 68 72 74 91 76 83 งงง 8 སྐྱ ཐྭ ༄ ཏྱཾ 89 81 71 85 99 59 92 87 84 75 77 51 45 80 84 93 69 76 89 75 67 92 89 82 96 77 102 66 68 61 73 72 76 73 77 79 94 63 59 62 71 81 65 73 63 63 89 82 64 85 92 64 73 a. What is the variable? What type? b. Construct an interval-frequency table, with columns containing: class mark, absolute frequency, relative frequency, cumulative frequency, cumulative relative frequency, and percentage frequency.arrow_forward
- This is the information about the actors who won the Best Actor Oscar: Best actors 44 41 62 52 41 34 34 52 41 37 38 34 32 40 43 56 41 39 49 57 35 30 39 41 44 41 38 42 52 51 49 35 47 31 47 37 57 42 45 42 44 62 43 42 48 49 56 38 60 30 40 42 36 76 39 53 45 36 62 43 51 32 42 54 52 37 38 32 45 60 46 40 36 47 29 43 a. What is the variable? What type? b. Construct an interval-frequency table, with columns containing: class mark, absolute frequency, relative frequency, cumulative frequency, cumulative relative frequency, and percentage frequency.arrow_forwardans c plsarrow_forwardCritically analyze the following graph and, based on statistical information, indicate the type of error it presents IN NO MORE THAN 3 LINES SCOTCEN POLL OF POLLS SHOULD SCOTLAND BE INDEPENDENT? NO 52% YES 58% LIVE CAW NAS & 28.30 HAS KILLED MORE THAN 2,600 IN WEST AFRICA, WORLD HEALTH ORG. BROOKEBCNNarrow_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
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