Creating a Histogram in Excel
Method 1: Using the Histogram Tool in the Analysis Tool-Pak.
This is probably the easiest method, but you have to re-run the tool each to you do a new
simulation. AND, you still need to create an array of bins (which will be
William Jue
Math 240
Ch.10: Fundamentals of Hypothesis Testing: Two Sample Tests
10.9
a) Because tstat = -2.0262 < -0.35, you do not reject the null hypothesis. There is not enough evidence to conclude
that the mean waiting time is different between the t
William Jue
Math 240
Chapter 8: Confidence Interval Estimation
8.9
a) 0.995
2.58(0.02/ 50 = 0.995 0.007297
We are 99% confident that the true mean resistance is between 0.987703 and 1.002297 gallons.
b) Based on the results, the manager does not have the
William Jue
Math 240
Ch.9: Fundamentals of Hypothesis Testing: One Sample Tests
9.3
Do not reject the null hypothesis at =0.10. There isnt sufficient evidence to reject at the population mean of 500.
9.8
The p-value for Zstat = -1.38, in a two-tail hypoth
Wiliam Jue
Math 240
Chapter 6: Normal Distribution
6.3
a) The probability that Z is less than 1.08 is 0.8599 or 85.99%.
b) The probability that Z is greater than -0.21 is 05832 or 58.32%.
c) The probability that Z is less than -0.21 or greater than the me
William Jue
Math 240
Ch.13: Simple Linear Regression
13.7
a)
5
4.5
4
3.5
3
2.5
Y
f(x) = 0.5x + 0.75
2
R = 0.38
1.5
1
0.5
-4
-3
-2
-1
0
0
1
X
b) b0 = 0.75, b1=0.50
c) For every 1.0 increase in the plate gap, the bag tearing will increase by 0.5.
d) If the
Confidence Interval Estimate
Data
X Value
Confidence Level
Intermediate Calculations
Sample Size
Degrees of Freedom
t Value
XBar, Sample Mean of X
Sum of Squared Differences from XBar
Standard Error of the Estimate
h Statistic
Predicted Y (YHat)
150
95%
2
Honors Algebra 2: Conceptual Unit 1 NOTES
8.1 DAY 1
8.1 DAY 2
8.2 DAY 1
8.2 DAY 2
Honors Algebra 2: Lesson: 8.1 Day 1: Systems of Linear Equations in Two Variables
NOTES:
System of Linear equations: 2 or more linear equations (1st degree; y = mx + b)
Solu
Page 1
Math 240 Final Exam
Name_
1.
A confidence interval was used to estimate the proportion of statistics
students that are female. A random sample of 72 statistics students
generated the following 90% confidence interval: (0.438, 0.642). Using
the info
Wiliam Jue
Math 240
Chapter 7: Sampling and Sampling Distributions
7.11
a) P=14/40=0.35
b) 0.072457
7.16
a) 0.6542
b) The probability 90% of the sample will be contained is 0.06 and 0.14.
c) The probability 95% of the sample will be contained is 0.05 and
Wiliam Jue
Math 240
Chapter 5: Binomial & Poisson Distributions
5.14
a) Stock X: $71, Stock Y: $97
b) Stock X: $61.88, Stock Y: $84.27
c) $5,113
d) I would invest in Stock Y because the expected return is higher and the standard deviation is lower
meaning
Normal Probability Calculations Using PHStat
Question 1:
Go into PHStat:
Enter the numbers for the problem:
Bingo, here is your answer:
Question 2:
Enter the data into PHStat for the same function (make sure you check the right box):
and the answer:
Quest
Confidence Interval Estimate
Data
X Value
Confidence Level
1
95%
Intermediate Calculations
Sample Size
Degrees of Freedom
t Value
XBar, Sample Mean of X
Sum of Squared Differences from XBar
Standard Error of the Estimate
h Statistic
Predicted Y (YHat)
19
William Jue
Math 240
Ch.14: Multiple Regression
14.6
a) Y=b0+bx1+bx2
Y=156.4304+13.0807x1+16.7953x2
b) bx1=For every $1,000 increase in Radio Advertising, the sales will increase by $13,081.
bx2=For every $1,000 increase in Newspaper Advertising, the sale
William Jue
Math 240
Ch.15: Multiple Regression Model Building
15.4
a) y=21.0215x1+3.981x2-3.7203
y=Calories in the beer
x1=Alcohol %
x2=Carbohydrates
b) y=14.96285x1+4.3599x2+0.4817 x3-0.0134 x4+11.5227
y=Calories in the beer
x1=Alcohol %
x2=Carbohydrate
Confidence Interval Estimate and Prediction Interval
Data
Confidence Level
Radio given value
Newspaper given value
X'X
95%
PHStat User Note:
1
Enter the values for the given
0
X's in the cell range B6:B7.
(You can interactively change
0
these values at an
Wiliam Jue
Math 240
Chapter 4: Basic Probability Concepts
4.14
Gender
Do you enjoy
shopping for
clothing for
yourself
Yes
No
a)
b)
c)
d)
Male
Female
Total
238
276
514
304
267
571
542
543
1085
514/1085 equals 47%
276/1085 equals 25%
(543/1085)+(514/1085)-(
Wiliam Jue
Math 240
Chapter 3: Numerical Descriptive Measures
3.62
The covariance and the coefficient of correlation differ due to the covariance measuring the strength of
the linear relationship between two numerical variables while the coefficient of co
Problems 15.4, 15.11, 15.25, 15.30
Problem 15.4
Part A
Regression Analysis
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
b2 , b1 , b0 intercepts
b2, b1, b0 Standard Error
R Square, Standard Error
F , Residual df
R