Show work

Regression Analysis: Using the Dataset P10_20 perform linear regression analyses using each of the various possible independent variables to predict the number of weekly riders. Based on your analyses, what's the best equation to use and why? Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Weekly Riders 1,200 1,190 1,195 1,100 1,105 1,115 1,130 1,095 1,090 1,087 1,080 1,020 1,010 1,010 1,005 995 930 915 920 940 950 910 930 933 940 948 955 Price per Ride $0.15 $0.15 $0.15 $0.25 $0.25 $0.25 $0.25 $0.30 $0.30 $0.30 $0.30 $0.40 $0.40 $0.40 $0.40 $0.40 $0.75 $0.75 $0.75 $0.75 $0.75 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 Population 1,800 1,790 1,780 1,778 1,750 1,740 1,725 1,725 1,720 1,705 1,710 1,700 1,695 1,695 1,690 1,630 1,640 1,635 1,630 1,620 1,615 1,605 1,590 1,595 1,590 1,600 1,610 Income $2,900 $3,100 $3,200 $3,250 $3,275 $3,290 $4,100 $4,300 $4,400 $4,600 $4,815 $5,285 $5,665 $5,800 $5,900 $5,915 $6,325 $6,500 $6,612 $6,883 $7,005 $7,234 $7,500 $7,600 $7,800 $8,000 $8,100 Parking Rate $0.50 $0.50 $0.60 $0.60 $0.60 $0.70 $0.75 $0.75 $0.75 $0.80 $0.80 $0.80 $0.85 $1.00 $1.05 $1.05 $1.05 $1.10 $1.25 $1.30 $1.50 $1.55 $1.65 $1.75 $1.75 $1.90 $2.00