you gave me this answer in last question, (copied below) but I see why I wasn't finding the correct p-value. I don't know how to get this from excel or in the z table.  My z table gives me answeres to the left of z. and when I put my excel formula in which is  =norm.s.dist(1.99, true) I get same answer as in z table to the left.             A-how do I get answer for p-value when mu is greater than 85 like below problem?  B- Also, how do I get answer for P-value when its a two tail test and mu differs?   Step 1 Given data of glucose reading for 8 weeks92 87 82 107 99 109 85 89The sample x-bar is 93.8 . x is normal distribution with standard deviation = 12.5 Given that the mean glucose levelfor horses is µ = 85 mg/100glclaim is that to see if the gentle Ben have glucose level higher than 85 at 0.05 level of significance. Null hypothesis : µ = 85Alternative hypothesis : µ > 85. As x is normally distributed we use one sample Z test. So the test statistic Z is calculate dby using the below mentioned formula and by substituting values we get the test statistic as  1.99 (after rounding to two decimals). help_outlinefullscreen Step 2 With reference to the Z table we can see that the area to the right of 1.99 is 0.0233. As this is one tail test. The p value is nothing but the the proportion of data to right of test statistic p value = P( X > 1.99) = 0.0233.

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter1: Fundamental Concepts Of Algebra
Section1.2: Exponents And Radicals
Problem 92E
icon
Related questions
icon
Concept explainers
Topic Video
Question
you gave me this answer in last question, (copied below) but I see why I wasn't finding the correct p-value.
I don't know how to get this from excel or in the z table.  My z table gives me answeres to the left of z. and when I put my excel formula in which is 
=norm.s.dist(1.99, true) I get same answer as in z table to the left.             A-how do I get answer for p-value when mu is greater than 85 like below problem?
 B- Also, how do I get answer for P-value when its a two tail test and mu differs?
 
Step 1

Given data of glucose reading for 8 weeks
92 87 82 107 99 109 85 89
The sample x-bar is 93.8 . 
x is normal distribution with standard deviation = 12.5

Given that the mean glucose levelfor horses is µ = 85 mg/100gl
claim is that to see if the gentle Ben have glucose level higher than 85 at 0.05 level of significance.

Null hypothesis : µ = 85
Alternative hypothesis : µ > 85.

As x is normally distributed we use one sample Z test. So the test statistic Z is calculate dby using the below mentioned formula and by substituting values we get the test statistic as  1.99 (after rounding to two decimals).

help_outlinefullscreen
Step 2

With reference to the Z table we can see that the area to the right of 1.99 is 0.0233. As this is one tail test. The p value is nothing but the the proportion of data to right of test statistic p value = P( X > 1.99) = 0.0233.

 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 1 images

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage