In Excel, using the following data, create a:
Scatter Plot
Linear Regression Equation (with interpretation)
Coefficient of Determination (with interpretation)
Coefficient of Correlation (with interpretation)
Be sure to list each step taken in Excel
Length of Stay Total Charges
3 $5,418.85
3 $4,575.10
11 $12,031.18
3 $3,617.84
9 $12,806.88
3 $5,295.55
3 $3,453.21
3 $1,760.03
3 $3,290.40
5 $6,253.65
3 $3,896.16
2 $1,795.35
3 $9,265.17
3 $3,282.90
5 $9,565.83
3 $3,782.15
4 $6,384.28
3 $4,904.25
2 $4,169.92
3 $5,204.41
4 $6,740.00
1 $5,016.44
2 $4,178.94
3 $4,105.26
4 $4,717.30
6 $6,598.92
2 $1,633.85
1 $2,200.85
4 $7,461.54
5 $11,413.23
3 $5,607.55
2 $4,850.62
4 $7,102.49
15 $13,615.69
3 $5,069.18
6 $6,536.07
4 $7,401.25
2 $3,744.34
5 $8,653.68
9 $14,423.21
3 $3,742.30
3 $5,514.09
5 $7,390.15
5 $9,358.20
7 $14,570.29
4 $4,526.43
6 $6,846.77
2 $2,927.62
3 $4,404.13
6 $8,056.36
8 $10,703.34
4 $16,458.95
5 $4,770.10
8 $15,282.57
7 $10,105.30
8 $7,871.29
3 $3,411.10
12 $10,962.17
2 $7,374.27
5 $7,788.51
5 $8,191.10
3 $11,117.35
2 $5,624.54
4 $4,574.92
3 $3,644.36
2 $2,937.92
6 $3,944.78
3 $6,366.10
3 $4,992.01
4 $6,929.35
5 $5,595.42
3 $3,466.70
7 $7,289.77
7 $6,375.95
3 $3,585.62
4 $5,970.45
8 $10,578.14
2 $2,223.60
3 $2,250.50
1 $1,644.55
4 $2,491.45
3 $1,691.50
6 $7,931.92
5 $5,121.97
5 $6,940.75
7 $12,088.08
1 $2,325.60
2 $4,452.78
4 $6,157.43
11 $21,474.90
3 $8,566.51
2 $4,910.27
1 $3,275.03
4 $12,080.81
6 $7,436.85
8 $15,624.20
4 $4,590.48
2 $3,232.63
3 $3,768.11
7 $9,862.26
7 $10,626.42
4 $6,967.99
3 $5,891.25
3 $4,756.91
9 $8,096.93
4 $4,620.59
6 $5,796.49
1 $1,483.39
1 $2,510.05
6 $10,185.83
3 $3,391.90
5 $8,418.13
3 $4,346.47
2 $2,043.85
3 $2,594.85
5 $5,499.36
9 $11,244.45
7 $6,565.55
4 $6,031.15
7 $4,912.76
3 $6,182.45
3 $4,218.95
16 $40,231.27
3 $3,608.95
4 $3,041.44
1 $1,581.93
2 $1,468.48
2 $2,294.55
2 $7,138.72
3 $3,845.96
4 $5,355.23
4 $4,573.05
5 $5,023.11
5 $4,238.30
5 $6,885.73
5 $5,447.63
7 $6,257.66
2 $4,601.00