Solve the following in excel while showing all formulas Inferential Statistics: Confidence interval Find the following using excel If P(z k)=0.025, k= If P(z k)=0.01,

Solve the following in excel while showing all formulas

Inferential Statistics: Confidence interval

1. Find the following using excel
   1. If P(z
   2. If P(z>k)=0.025, k=
   3. If P(z
   4. If P(z>k)=0.01, k=?
   5. t_0.025,100=?
   6. t_0.03,150=?

1. Obtain the following
2. 95% confidence interval for Average time spent on social media

					Interval Estimate
Population standard deviation	z or t interval?	alpha	Point estimate	B	LCL	UCL
2.34
Unknown

1. 90% confidence interval for average level of obesity

					Interval Estimate
Population standard deviation	z or t interval?	alpha	Point estimate	B	LCL	UCL
7.12
unknown

1. Stated confidence for the proportion of all students using Samsung as a smartphone

				Interval Estimate
z or t interval?	alpha	Point estimate	B	LCL	UCL
99%
85%

1. Using the z-confidence intervals, state whether the following claims can be true or false?
   1. The 95% confidence interval states that, on average, students spend more than 3.5 hours on social media
   2. The 90% confidence interval states that, on average, students are obese by more than 5 KG.
   3. The 99% confidence interval estimate shows that the student market share of Samsung is 33%
   4. The 85% confidence interval estimate shows that the student market share of Samsung is 33%