The table below contains the average public school classroom teacher's salaries, yy, for an 11-year period. If xx represents the number of years since 1990, use Excel to find a linear model for the data. Year 1990 1991 1992 1993 1994 1995 Salary 33855 35031 34984 34221 35488 37443 Year 1996 1997 1998 1999 2000 Salary 37188 40370 40627 41311 43954 With the salary given by y=mx+b m=? b=?
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
I do not have data analysis on my excel, I have no idea how to solve this.
The table below contains the average public school classroom teacher's salaries, yy, for an 11-year period. If xx represents the number of years since 1990, use Excel to find a linear model for the data.
| Year | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 |
| Salary | 33855 | 35031 | 34984 | 34221 | 35488 | 37443 |
| Year | 1996 | 1997 | 1998 | 1999 | 2000 |
| Salary | 37188 | 40370 | 40627 | 41311 | 43954 |
With the salary given by y=mx+b
m=?
b=?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
