QSO 510: Derivative of a Function Review
Notes
Use the instructions given in the document Using Excel for Regression Analysis for doing scatter
plot, inserting the trend line and producing the regression report using the data analysis regression
tool.
C
QSO510:ForecastingSolutions
Problem1Solution
a) Thegraphofozoneratevs.timeisgivenbelow.Fromthegraph,itappearsthataverageozonerate
istrendingupovertime.
Average Ozone Rate
Average Oz one Rate
7
6
5
4
3
2
1
0
Jan
Feb
Mar
Apr
May
Jun
Month
b) ForecastsforJu
QSO 510: Estimation & Hypothesis Testing
Review
Problem 1
A real estate broker for Gieselman and Associates randomly selected four properties from a
subdivision, and an appraiser gave an opinion on the value of each property as $17, $21, $21,
and $21 thou
QSO510:StatisticalFundamentalsReview
Themonthlyaveragehightemperaturesfromwww.weather.comduringdifferentmonthsofyearat
Manchester,NHaregivenbelow:
January
February
March
April
May
June
32
36
44
56
68
77
July
August
September
October
November
December
82