In: Statistics and Probability
Disk drives have been getting larger. Their capacity is now often given in terabytes (TB) where 1 TBequals1000 gigabytes, or about a trillion bytes. A survey of prices for external disk drives found the data shown to the right. For this data, we want to predict Price from Capacity.
Capacity: price:
.5 59.00
1 77.45
2 115.00
3 105.95
4 142.45
6 423.95
8 599.79
12 1075.45
32 4463
What is the intercept?
Bring data in to excel sheet
Select capacity and price data and go to insert tab --> choose scatter plot
Right click any data point of the data set and add trend line. In the format trend line option choose "linear"
If you want to predict the capacity, use regression equation to easily predict the numbers
y = 142.28x - 298.26
x is the prediction value.
say for example if you want to predict capacity for the value 15, below is the procedure
y = 142.28*15 - 298.26
y = 1835.94.
For the capacity 15 , predicted value is 1835.94
What is the intercept?
-298.26 is the y intercept
142.28x is the slope of the regression