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
please answer in text form and in proper format answer with must explanation , calculation for each part and steps clearly
arrow_forward
The following data represent the inventory figures for 55-gallon fish tanks at an aquarium.
*Chart Attached*
(A): How many fish tanks did the aquarium have available for sale?
__________________fish tanks
(B): Calculate the total cost (in $) of the tanks available for sale.
$____________
(C): If physical inventory on December 31 showed 88 tanks on hand, calculate their dollar value by using FIFO.
$____________
arrow_forward
What is 25/7 as a mixed numb X +
stincc.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_949094_1&course_id=
* Question Completion Status:
8
QUESTION 13
Use your calculator to write the following as a decimal and round to the specified place value.
1
Round to the nearest hundredth place.
23
Round
Round
47
100
to the nearest tenth place.
27
to the nearest ten-thousandths place. 2.0769
13
QUESTION 14
Choose or to compare the decimals.
-2.6
V -4.6
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
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
DUE NOW. Please answer the attached question in Microsoft Excel, preferably with the formula and file. Thank you!
arrow_forward
scott uses 41 cent stamps and 8 cent stamps to mail a memory card to a friend of the postage 1.95 how many of each stamp did scott use ?
arrow_forward
Please asssist with question b for all the missing values.
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
to
Calcu
on 1.2
Signit Bb My Bl
Digita
ng.ce
2/2
Week
et02-xythos.content.blackboardcdn.com/5fcfbb471fe01/26129793?X-Blackboard-S3-Bucket-learn-us-east-1-prod-fleet...
100% +
HOME
Cenga Bly Do-M P Do Ho
4. Write the equation of a line containing the point (5, 150) with slope m = Write your line in
slope-intercept form.
MacBook Air
5. Write the equation of a line containing the points (-4, 5) and (3, -2). Write your line in slope-
intercept form.
arrow_forward
st Assessment / 1 of 13
NC.6.NS.1
Mai biked 6-miles today, and Noah biked 4 miles. How many times the length of Noah's bike ride was Mai's bike ride?
4
ОА. 2
times as far
3.
3.
B.
times as far
2
6.
times as far
D. 243
times as far
arrow_forward
stats
anwser for the question that says: Do cell phone users appear to have a rate of cancer of the brain or nervous system that is different from the rate of such cancer among those not using cell phones?
arrow_forward
Between z=1.40 and z=2.03
arrow_forward
Details | bartleby
E New tab
A https://www.webassign.net/web/Student/Assignment-Responses/submit?dep=254878928&tags=autosave#question4023958_1
Sign in
Viewing Saved Work Revert to Last Response
DETAILS
HARMATHAP12 5.1.052.
MYΝΟΤΕS
The amount of money that needs to be deposited into an account to reach some future goal is called the present value. The following table gives the present value (to
the nearest dollar) for an account that earns 10% compounded annually so that the account value will be $50,000 after intervals ranging from 1 to 7 years.
Years
Present value
1
$45,455
41,322
3
37,566
4.
34,151
31,046
28,224
26,658
(a) Using x as the years and y as the present value (in dollars), develop an exponential model for these data. (Round your numerical values to four decimal places:)
y =
(b) Use the model to find the present value (to the nearest dollar) of this account for its value to be $50,000 after 11 years.
24
2:16 AM
12/5/2020
O Type here to search
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
Calculate MSE for the 4 periods for which the actual and forecasted number of customers given in the table below:
Period
Actual Number of Customers
Forecasted Number of Customers
Error
1
1,975
2,000
2
2,050
2,025
3
1,925
1,975
4
2,075
2,025
0
390.63
37.5
6,250
1,562.5
arrow_forward
The population of Ada County, Idaho has been steadily increasing for more than 20 years. The table below shows the population (people) from 2015 through 2019 in Ada County.
year
2015
2016
2017
2018
2019
population 432,862 444,486 456,548 468,764 481,587
a. What is the average rate of change in the population of Ada County from 2015 to 2018? Round to the nearest whole person and include units.
b. What is the average rate of change in the population of Ada County from 2016 to 2018? Round to the nearest whole person and include units.
c. What is the average rate of change in the population of Ada County from 2017 to 2018? Round to the nearest whole person and include units.
d. What is the average rate of change in the population of Ada County from 2018 to 2019? Round to the nearest whole person and include units.
e. Give a good approximation for the rate at which the population of Ada County is growing by the end of 2018? Round to the nearest whole person and include units.
arrow_forward
Answer all the questions please badly need:<
arrow_forward
X
What is 25/7 as a mixed numb X +
e.austincc.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_949094_1&course_id=_878122_1&cc
Question Completion Status:
QUESTION 9
Out of the 485 cookies for the bake sale,
2/5 were chocolate chip.
a. Estimate the number of chocolate chip cookies. Explain how you estimated.
b. Exactly how many chocolate chip cookies were at the bake sale?
Make sure you show all of your work and explain your estimation clearly to earn full credit.
Be sure to label your answers as part a and part b. Write your final answers in complete sentences.
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
B IUS Paragraph
V Arial
% 0
¶ 99 Ω
Q
FA
EEEE
163 20
EE
10pt
X² X₂ & Gr 1
111
BOMO BE
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
- please answer in text form and in proper format answer with must explanation , calculation for each part and steps clearlyarrow_forwardThe following data represent the inventory figures for 55-gallon fish tanks at an aquarium. *Chart Attached* (A): How many fish tanks did the aquarium have available for sale? __________________fish tanks (B): Calculate the total cost (in $) of the tanks available for sale. $____________ (C): If physical inventory on December 31 showed 88 tanks on hand, calculate their dollar value by using FIFO. $____________arrow_forwardWhat is 25/7 as a mixed numb X + stincc.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_949094_1&course_id= * Question Completion Status: 8 QUESTION 13 Use your calculator to write the following as a decimal and round to the specified place value. 1 Round to the nearest hundredth place. 23 Round Round 47 100 to the nearest tenth place. 27 to the nearest ten-thousandths place. 2.0769 13 QUESTION 14 Choose or to compare the decimals. -2.6 V -4.6arrow_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 672arrow_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_forwardDUE NOW. Please answer the attached question in Microsoft Excel, preferably with the formula and file. Thank you!arrow_forward
- scott uses 41 cent stamps and 8 cent stamps to mail a memory card to a friend of the postage 1.95 how many of each stamp did scott use ?arrow_forwardPlease asssist with question b for all the missing values.arrow_forwardWhat 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 672arrow_forward
- to Calcu on 1.2 Signit Bb My Bl Digita ng.ce 2/2 Week et02-xythos.content.blackboardcdn.com/5fcfbb471fe01/26129793?X-Blackboard-S3-Bucket-learn-us-east-1-prod-fleet... 100% + HOME Cenga Bly Do-M P Do Ho 4. Write the equation of a line containing the point (5, 150) with slope m = Write your line in slope-intercept form. MacBook Air 5. Write the equation of a line containing the points (-4, 5) and (3, -2). Write your line in slope- intercept form.arrow_forwardst Assessment / 1 of 13 NC.6.NS.1 Mai biked 6-miles today, and Noah biked 4 miles. How many times the length of Noah's bike ride was Mai's bike ride? 4 ОА. 2 times as far 3. 3. B. times as far 2 6. times as far D. 243 times as fararrow_forwardstats anwser for the question that says: Do cell phone users appear to have a rate of cancer of the brain or nervous system that is different from the rate of such cancer among those not using cell phones?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