VBA EXCEL

profilebestprof2
LinearRegression.xlsm
Home>Computer Science homework help>VBA EXCEL

Sheet1

Linear Regression:
User Instructions:
INPUT AREA OUTPUT AREA
Number of Data Points:
Raw Data Linear Fit
TotalTime (seconds) Velocity (meters/sec) TotalTime (seconds) Velocity (meters/sec)
0.00 0.00 0.00
0.10 0.19 3.75
0.20 0.15 7.50
0.30 0.17
0.40 0.19
0.50 0.21
0.60 0.21
0.70 0.24
0.80 0.25
0.90 0.32
1.00 0.23
1.10 0.41
1.20 0.52
1.30 0.29
1.40 0.43
1.50 0.44
1.60 0.39
1.70 0.42
1.80 0.55
1.90 0.62
2.00 0.57
2.10 0.53
2.20 0.52
2.30 0.41
2.40 0.58
2.50 0.74
2.60 0.62
2.70 0.62
2.80 0.67
2.90 0.70
3.00 0.58
3.10 0.70
3.20 0.74
3.30 0.62
3.40 0.69
3.50 0.74
3.60 0.71
3.70 0.71
3.80 0.74
3.90 0.80
4.00 0.79
4.10 0.74
4.20 0.72
4.30 0.72
4.40 0.89
4.50 0.85
4.60 0.79
4.70 0.81
4.80 0.79
4.90 0.79
5.00 0.70
5.10 0.80
5.20 0.85
5.30 0.94
5.40 0.94
5.50 0.75
5.60 0.91
5.70 0.94
5.80 0.84
5.90 0.95
6.00 0.88
6.10 0.85
6.20 0.95
6.30 0.83
6.40 0.83
6.50 1.08
6.60 1.00
6.70 0.95
6.80 0.95
6.90 0.95
7.00 0.97
7.10 0.75
7.20 0.77
7.30 1.26
7.40 1.27
7.50 0.94