LC_Larrreal_Continuous_Probability_Distribution_Normal_Start (1)
xlsx
keyboard_arrow_up
School
Eastern Kentucky University *
*We aren’t endorsed by this school
Course
890
Subject
Statistics
Date
Jan 9, 2024
Type
xlsx
Pages
11
Uploaded by PrivateInternetBarracuda38
Sub
This is a machine generated report of your submission document containing error
Details of all points deducted in the submitted document are listed on this sheet.
Assignment Details
Submission ID
314213501
Assignment Name
Submission Date
11 October, 2023
Report Generated on
11 October, 2023
Points Obtained
0/100 (0%)
Worksheet: 'Questions' (Points Deducted: 100.000)
Points Deducted
Details
100.000
Cell level Incorrect Actions
0.000
Missing: Row 26
bmission MarkUp
r details as annotations.
Error Description
22 cell(s) commented inplace. Please check the sheet.
This action did not result in any loss of points.
Contin
Project D
Steps to P
Step
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
The prese
of 420.5 m
We will us
approxima
Use a cell
full credit
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
21
22
23
24
nuous Probability Distribution: Normal
Description: Perform:
Instructions
Start Excel. Download and open the workbook named: Continuous_Probability_Distribution_Normal_Start
What is the population mean (µ)? Choose your answer from the dropdown menu in cell C4.
What is the population standard deviation (σ)? Choose your answer from the dropdown menu in cell C5.
In cell C9, find the probability that a Camry L will travel between 380 and 500 miles on a full tank of gas using the values in Hint: use the NORM.S.DIST function.
In cell C10, find the probability that a Camry L will travel less than 400 miles on a full tank of gas.
Hint: use the NORM.DIST function.
In cell C11, find the probability that a Camry L will travel more than 410 miles on a full tank of gas.
In cell C12, find the probability that a Camry L will travel less than 420.5 miles on a full tank of gas.
In cell C13, find the probability that a Camry L will travel exactly 410 miles on a full tank of gas.
Hint: an Excel function cannot be used to find the answer.
In cell C14, find the probability that a Camry L will travel between 400 and 450 miles on a full tank of gas.
In cell C15, find the probability that a Camry L will travel between 320 and 380 miles on a full tank of gas.
In cell C16, find the probability that a Camry L will travel between 430 and 490 miles on a full tank of gas.
In cell C17, determine the number of miles that the car will travel with 90% probability on a full tank of gas.
Hint: use the NORM.INV function.
In cell C18, determine the number of miles that the car will travel with 30% probability on a full tank of gas.
In cell C19, determine the number of miles that the car will travel with 50% probability on a full tank of gas.
In cell C20, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes a
In cell C21, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes a
In cell C22, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes a
ent study shows the data for the miles driven by the 2018 Toyota Camry L. According to the Environmental Prote
miles on a full tank of gas. A researcher is interested in analyzing the data and finding z-scores and probabilities se cell referencing and Excel functions to find standardized z-scores and probabilities. We will apply the empirica
ately 68%, 95%, and 99.7% of the data. Assume the mileage follows a normal distribution with a standard devia
l reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or for your answers.
In cell C6, find the z-score for
x = 380.
In cell C7, find the z-score for
x = 500.
In cell C8, find the z-score for
x = 420.5.
In cell C23, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes a
In cell C24, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that includes a
In cell C25, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that includes a
Save your file and submit it for grading.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Points
Possible 0
3
3
5
5
5
5
5
5
5
5
5
5
5
5
5
5
4
4
4
n average receive
4
4
4
0
100
Con
1-2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
Use a
your Accor
devia
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ntinuous Probability Distribution: Normal
In cell C9, find the probability that a Camry L will travel between 380 and 500 miles on a full tank of gas using the va
In cell C10, find the probability that a Camry L will travel less than 400 miles on a full tank of gas.
In cell C11, find the probability that a Camry L will travel more than 410 miles on a full tank of gas.
In cell C12, find the probability that a Camry L will travel less than 420.5 miles on a full tank of gas.
In cell C13, find the probability that a Camry L will travel exactly 410 miles on a full tank of gas.
In cell C14, find the probability that a Camry L will travel between 400 and 450 miles on a full tank of gas.
In cell C15, find the probability that a Camry L will travel between 320 and 380 miles on a full tank of gas.
In cell C16, find the probability that a Camry L will travel between 430 and 490 miles on a full tank of gas.
In cell C17, determine the number of miles that the car will travel with 90% probability on a full tank of gas.
In cell C18, determine the number of miles that the car will travel with 30% probability on a full tank of gas.
In cell C19, determine the number of miles that the car will travel with 50% probability on a full tank of gas.
In cell C20, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that inc
In cell C21, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that inc
In cell C22, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that inc
In cell C23, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that inc
In cell C24, determine the lower value for the interval of miles traveled on a full tank of gas around the mean that inc
In cell C25, determine the upper value for the interval of miles traveled on a full tank of gas around the mean that inc
a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste valu
answers.
rding to the Environmental Protection Agency (EPA), the 2018 Toyota Camry L drives an average of 420.5 miles o
ation of 50 miles. Answer the following questions:
What is the population mean (
µ
)? Choose your answer from the dropdown menu in cell C4.
What is the population standard deviation (
σ
)? Choose your answer from the dropdown menu in cell C5.
In cell C6, find the z-score for
x = 380.
In cell C7, find the z-score for
x = 500.
In cell C8, find the z-score for
x = 420.5.
420.5
50
-0.81
1.59
0.00
73.5%
34.1%
58.3%
50.0%
0.0%
38.2%
18.7%
-149.3%
484.6
394.3
420.5
370.5
470.5
320.5
520.5
270.5
570.5
dit for standard
Related Documents
Related Questions
Hello, I sent a question on this yesterday and no answer - how can I enter this data in spss?
Note, this is the same question from yesterday which was deducted leaving my balance as 28, so I expect it will remain the same since you did not reply adn I am writing the same question again.
Thanks
arrow_forward
What was discharge rate for January 2, 2017?
Admissions and discharges in hospital
Jan. 1, 2017
Jan. 2, 2017
Jan. 3, 2017
Admissions
896
649
1,503
Discharges
764
543
672
arrow_forward
Please help, this is one full question.
arrow_forward
what is mode and how do i find it?
arrow_forward
Construct a box plot for the FTES for 2005–2006 through 2010–2011 and a box plot for the FTES for 1976–1977through 2004–2005.
arrow_forward
The price per share of stock for a sample of 25 companies was recorded at the beginning of the first financial quarter and then again at the end of the first financial quarter. How stocks perform during the first
quarter is an indicator of what is ahead for the stock market and the economy. Use the sample data in the file StockQuarter to answer the following.
Click on the datafile logo to reference the data.
DATA file
a. Let di denote the percentage change in price per share for company i where
7.46
Confidence interval
Interpret this result.
The stock market experiences a decline
Company
Bank of New York Mellon
Kraft Foods
E.I. du Pont de Nemours and Company
Consolidated Edison
) (to 3 decimals)
Johnson & Johnson
Union Pacific
Comcast
Applied Materials.
Pfizer
General Electric
AT&T
Cisco Systems
Home Depot
✔
JP Morgan Chase
Procter & Gamble
Verizon
Devon Energy
Lilly
Microsoft
Coca Cola
Qualcomm
Exxon Mobil Corporation
PG&E Corporation
Oracle Corporation
Chevron
end of 1st quarter…
arrow_forward
Handwritten only
arrow_forward
at
2 presented based on the Health Information National Trends Survey (HINTS)
LALYSIS
arrow_forward
solve for UCLp
arrow_forward
Calculate P(eating breakfast | age 14-17 )
arrow_forward
What was admission rate for January 3, 2017?
Admissions and discharges in hospital
Jan. 1, 2017
Jan. 2, 2017
Jan. 3, 2017
Admissions
896
649
1,503
Discharges
764
543
672
arrow_forward
Please give an analysis of the photo. Thank you
arrow_forward
An insurance company hires an actuary to determine whether the number of hours of safety drivingclasses can be used to predict the number of driving accidents for each driver. Identify theexplanatory variable, if any.
arrow_forward
Suppose that the Producer Price Index and the sales of Hoskin’s Wholesale Distributors for 2006 and 2018 are:
What are Hoskin's real sales (also called deflated sales) for the 2 years? (Round your answers to the nearest whole dollar.)
arrow_forward
Please explain. I am very lost ):
arrow_forward
Last month, the Women's Hospital reported 123 obstetrical discharges and five deaths. (The deaths are
included in the discharges.) The causes of the five deaths were:
• Injuries due to spousal abuse
• Injuries due to an automobile accident
• Suicide
• Hemorrhage after C-section due to severed uterine artery
• Pre-eclampsia
Calculate the direct maternal mortality rate for this hospital. Round to two decimal places.
arrow_forward
The American Heart Association is about to conduct an anti-smoking campaign and wants to know the fraction of Americans over 3232 who smoke.
Step 1 of 2 :
Suppose a sample of 20172017 Americans over 3232 is drawn. Of these people, 665665 smoke. Using the data, estimate the proportion of Americans over 3232 who smoke. Enter your answer as a fraction or a decimal number rounded to three decimal places.
arrow_forward
Someone help please! It says I got partial credit for this frequency table but I reviewed it and I have no idea what is it I got wrong. Please double-check this for me. Thank you
arrow_forward
The accompanying table pertains to scheduled commercial carriers for a certain country. The third year was an anomaly. If the
anomalous numbers are removed from the data for the third year (4 of the 7 fatal accidents and 261 of the 531 fatalities
were anomalous), which of the three measures for fatalities change and what are their new values for each of them?
Click the icon to view the commercial carrier data for the country.
...
Select the correct choice below and, if necessary, fill in the answer box to complete your choice.
(Simplify your answer. Type an integer or a decimal. Do not round.)
OA. The new median is
The mean and mode remain the same.
The median and mode remain the same.
OB. The new mean is
OC. The new mode is
D. The mean, the median, and the mode all remain the same.
The mean and the median remain the same.
arrow_forward
Please provide answer in 1 hr
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Related Questions
- Hello, I sent a question on this yesterday and no answer - how can I enter this data in spss? Note, this is the same question from yesterday which was deducted leaving my balance as 28, so I expect it will remain the same since you did not reply adn I am writing the same question again. Thanksarrow_forwardWhat was discharge rate for January 2, 2017? Admissions and discharges in hospital Jan. 1, 2017 Jan. 2, 2017 Jan. 3, 2017 Admissions 896 649 1,503 Discharges 764 543 672arrow_forwardPlease help, this is one full question.arrow_forward
- what is mode and how do i find it?arrow_forwardConstruct a box plot for the FTES for 2005–2006 through 2010–2011 and a box plot for the FTES for 1976–1977through 2004–2005.arrow_forwardThe price per share of stock for a sample of 25 companies was recorded at the beginning of the first financial quarter and then again at the end of the first financial quarter. How stocks perform during the first quarter is an indicator of what is ahead for the stock market and the economy. Use the sample data in the file StockQuarter to answer the following. Click on the datafile logo to reference the data. DATA file a. Let di denote the percentage change in price per share for company i where 7.46 Confidence interval Interpret this result. The stock market experiences a decline Company Bank of New York Mellon Kraft Foods E.I. du Pont de Nemours and Company Consolidated Edison ) (to 3 decimals) Johnson & Johnson Union Pacific Comcast Applied Materials. Pfizer General Electric AT&T Cisco Systems Home Depot ✔ JP Morgan Chase Procter & Gamble Verizon Devon Energy Lilly Microsoft Coca Cola Qualcomm Exxon Mobil Corporation PG&E Corporation Oracle Corporation Chevron end of 1st quarter…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning

College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning