Need to construct a 99% confidence inverts for the population mean. The second picture is information about the the sample but not in a 99% confidence interval. Thank you! i. Mean=AVERAGE(B2:B600) =65,039ii. Median=MEDIAN(B2:B600) =58,710iii. Mode=MODE(B2:B600) =49970iv. Midrange=MAX(B2:B600) =198,110=MIN(B2:B600) =30,980198,110+30,980=229,090229,090/2=114,545v. Range=MAX(B2:B600)-MIN(B2:B600) =167,130vi. Variance=VAR.P(B2:B600) =724429866.7vii. Standard Deviation=STDEV.P(B2:B600) =26915.23484 Paste py14012345678920212223242526272829ReadyFormat PainterClipboardABXCalibriBIUCPage LayoutfxVData Question 1Accessibility: Good to goType here to searchD✓11FontVwwwmters_DeliveraEFormulasQuestion 2A A• Α' Α'VAVF2Data ReviewQuestion 3====comuence Intervals_08092022 • Saved ✓G1View HelpAlignmentHO 발FolloWrap TextMerge & Center ✓3. Using the data from the 'Data' tab in this workbook, construct a 99% confidence interval for the populationmean. Assume that your data is normally distributed and o is unknown. Include a statement that correctlyinterprets the confidence interval in context of the scenario.Question 4 Question 5|Hint: Use the sample mean and sample standard deviation from Deliverable 1. Do NOT copy and paste the values.Instead, use cell referencing to use the unrounded values.Calculate all of the values needed to create this confidence interval to the right.Below, include a breakdown of the steps, include formulas, and correctly interpret the solution in context of thescenario with the correct units.yGeneral407$ % 900 00KVSearch (Alt+Q)NumberLLUNlynConditional Format as CellFormattingTable VStylesMCalculations/ValuesVMeanStandard DeviationCritical ValueMargin of ErrorLower LimitUpper LimitGWStylesNVFormulas/Answers71%Insert DeleteCellsO815

Given that: Sample mean, x¯=65039 Sample standard deviation, s=26915.23484 Sample size is, n= 599…

Answered: Need to construct a 99% confidence…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

100%

Need to construct a 99% confidence inverts for the population mean. The second picture is information about the the sample but not in a 99% confidence interval. Thank you!

i. Mean
=AVERAGE(B2:B600) =65,039
ii. Median
=MEDIAN(B2:B600) =58,710
iii. Mode
=MODE(B2:B600) =49970
iv. Midrange
=MAX(B2:B600) =198,110
=MIN(B2:B600) =30,980
198,110+30,980=229,090
229,090/2=114,545
v. Range
=MAX(B2:B600)-MIN(B2:B600) =167,130
vi. Variance
=VAR.P(B2:B600) =724429866.7
vii. Standard Deviation
=STDEV.P(B2:B600) =26915.23484

Paste py
14
0
1
2
3
4
5
6
7
8
9
20
21
22
23
24
25
26
27
28
29
Ready
Format Painter
Clipboard
A
B
X
Calibri
BIU
C
Page Layout
fx
V
Data Question 1
Accessibility: Good to go
Type here to search
D
✓11
Font
V
wwwmters_Delivera
E
Formulas
Question 2
A A
• Α' Α'
V
A
V
F
2
Data Review
Question 3
===
=
comuence Intervals_08092022 • Saved ✓
G
1
View Help
Alignment
H
O 발
Follo
Wrap Text
Merge & Center ✓
3. Using the data from the 'Data' tab in this workbook, construct a 99% confidence interval for the population
mean. Assume that your data is normally distributed and o is unknown. Include a statement that correctly
interprets the confidence interval in context of the scenario.
Question 4 Question 5
|
Hint: Use the sample mean and sample standard deviation from Deliverable 1. Do NOT copy and paste the values.
Instead, use cell referencing to use the unrounded values.
Calculate all of the values needed to create this confidence interval to the right.
Below, include a breakdown of the steps, include formulas, and correctly interpret the solution in context of the
scenario with the correct units.
y
General
407
$ % 900 00
K
V
Search (Alt+Q)
Number
L
LUN
ly
n
Conditional Format as Cell
Formatting
Table V
Styles
M
Calculations/Values
V
Mean
Standard Deviation
Critical Value
Margin of Error
Lower Limit
Upper Limit
G
W
Styles
N
V
Formulas/Answers
71%
Insert Delete
Cells
O
815

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Expert Solution