The labeled potency of a tablet dosage form is 100 mg. Ten individual tablets of a batch are assayed according to a quality control specification. The 10 assay results shown in Table 5.1 are assumed to be sampled from a normal distribution. The sample mean is 103.0 mg and the standard deviation is 2.22. Using Excel, answer the following questions of interest at significance level 0.05 1) Is the mean tablet potency of the batch is statistically equal to 100 assuming the standard deviation of the batch (s) is estimated as 2 mg.

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

quickly please 

The labeled potency of a tablet dosage form
is 100 mg. Ten individual tablets of a batch
are assayed according to a quality control
specification. The 10 assay results shown in
Table 5.1 are assumed to be sampled from a
normal distribution. The sample mean is
103.0 mg and the standard deviation is 2.22.
Using Excel, answer the following questions
of interest at significance level 0.05
1) Is the mean tablet potency of the batch
is statistically equal to 100 assuming the
standard deviation of the batch (s) is
estimated as 2 mg.
Transcribed Image Text:The labeled potency of a tablet dosage form is 100 mg. Ten individual tablets of a batch are assayed according to a quality control specification. The 10 assay results shown in Table 5.1 are assumed to be sampled from a normal distribution. The sample mean is 103.0 mg and the standard deviation is 2.22. Using Excel, answer the following questions of interest at significance level 0.05 1) Is the mean tablet potency of the batch is statistically equal to 100 assuming the standard deviation of the batch (s) is estimated as 2 mg.
C15
123456N000
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Get External Data
A
101.8
102.6
99.8
104.9
103.8
100.7
104.5
106.3
100.6
105
B
X
100
100
100
100
100
100
100
100
100
100
✔
C
s=2.22
X=103
fx
D
Get & Transforr
E
Transcribed Image Text:C15 123456N000 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Get External Data A 101.8 102.6 99.8 104.9 103.8 100.7 104.5 106.3 100.6 105 B X 100 100 100 100 100 100 100 100 100 100 ✔ C s=2.22 X=103 fx D Get & Transforr E
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON