Can I have help with these ?s. Data below.

Y X1 X2 X3 X4 X5

Price Fuel Weather Distance Traf load Pass

6.8 2.19 2.00 0.92 0 3

10.3 2.60 3.00 3.75 1 1

7.3 2.18 1.00 3.68 0 1

12.6 3.00 1.00 5.10 1 1

7.7 2.00 1.00 3.36 0 2

11.9 2.80 1.00 4.84 1 2

8.7 2.16 2.00 3.04 0 2

10.4 2.64 1.00 3.64 1 1

12.3 2.49 1.00 4.17 1 1

11.2 2.59 1.00 4.38 1 1

9.0 2.70 2.00 3.31 0 3

13.5 2.85 2.00 3.76 1 2

13.0 2.51 1.00 4.17 1 2

10.1 2.68 1.00 2.94 1 1

8.5 2.15 1.00 4.45 0 1

6.9 2.29 1.00 2.73 0 1

10.9 2.42 2.00 4.54 1 3

10.3 2.60 1.00 3.40 1 1

6.4 2.40 2.00 1.81 0 1

10.2 2.60 1.00 2.67 1 1

7.3 2.05 1.00 2.59 0 1

8.5 2.21 2.00 3.79 0 2

13.4 2.69 1.00 5.35 1 3

7.8 2.16 1.00 2.53 0 1

11.5 2.71 3.00 3.11 1 1

10.0 3.03 3.00 3.67 1 1

9.8 2.51 1.00 3.91 0 2

11.2 2.34 1.00 4.93 1 1

12.3 2.65 1.00 4.66 1 1

11.1 2.36 2.00 3.55 1 2

8.1 2.31 1.00 3.56 0 1

7.2 1.93 3.00 1.98 0 1

8.4 2.25 1.00 3.59 0 2

8.7 2.28 2.00 3.59 0 2

3.4 1.79 1.00 0.65 0 1

11.7 3.03 1.00 4.10 1 2

7.5 2.17 3.00 3.11 0 1

12.1 2.78 2.00 3.93 1 2

9.9 2.52 1.00 3.37 0 2

9.7 2.28 1.00 3.53 0 2

7.4 2.67 1.00 2.73 0 2

12.6 2.94 2.00 5.25 1 2

8.9 2.87 2.00 2.16 0 1

8.5 2.63 2.00 3.04 0 1

9.5 2.43 1.00 2.69 0 2

7.6 2.63 1.00 3.65 0 1

8.2 2.54 1.00 3.63 0 2

11.9 2.41 2.00 4.86 1 1

9.0 2.39 1.00 3.34 0 1

10.6 2.12 1.00 3.57 1 2

12.3 2.22 1.00 4.90 1 2

9.9 2.70 2.00 4.67 0 1

7.9 2.60 2.00 2.91 0 1

7.8 2.41 1.00 2.15 0 2

10.3 2.72 1.00 3.84 1 1

10.0 2.59 2.00 2.79 0 1

7.9 2.40 2.00 2.16 0 2

10.6 2.55 1.00 3.48 1 1

9.1 2.16 1.00 2.82 0 1

10.0 2.62 2.00 4.10 1 3

9.9 2.31 1.00 2.70 0 1

11.5 2.54 2.00 4.49 1 2

10.8 2.62 1.00 3.28 1 2

11.8 2.73 1.00 5.25 1 2

9.9 2.55 1.00 3.59 0 1

9.3 2.23 1.00 3.57 0 1

10.4 2.37 1.00 3.73 1 2

9.4 2.58 1.00 3.11 0 1

8.4 2.27 1.00 4.08 0 2

11.4 2.57 1.00 3.93 1 1

12.0 2.87 1.00 5.60 1 1

9.2 2.07 1.00 2.42 0 1

13.0 3.14 2.00 4.34 1 1

10.6 2.49 3.00 3.34 1 1

10.4 2.29 1.00 3.42 1 1

11.6 2.62 2.00 3.55 1 1

7.6 2.75 2.00 2.34 0 2

9.3 2.50 1.00 3.25 0 1

7.5 2.42 2.00 2.14 0 1

9.5 2.79 1.00 3.54 0 2

6.2 1.90 2.00 1.37 0 2

12.6 2.41 1.00 4.37 1 1

8.0 2.70 1.00 2.97 0 1

9.4 2.60 2.00 3.71 0 1

11.7 3.02 1.00 4.99 1 1

10.4 2.62 1.00 3.29 1 1

5.2 2.52 1.00 1.79 0 1

8.8 2.34 3.00 1.50 0 1

11.8 2.94 3.00 3.11 1 1

11.6 2.31 1.00 3.65 1 1

7.8 2.55 2.00 2.66 0 1

10.9 2.86 2.00 3.23 1 2

11.2 2.42 2.00 3.82 1 3

13.4 2.85 1.00 4.67 1 2

9.0 2.49 2.00 2.82 0 1

6.4 2.44 1.00 1.70 0 1

11.8 2.37 1.00 2.93 1 2

11.7 2.56 1.00 4.37 1 2

10.0 2.61 2.00 3.65 0 1

9.7 2.68 1.00 1.38 0 2

11.8 2.53 1.00 4.43 1 2

12.0 2.55 1.00 4.64 1 1

4.0 2.00 1.00 0.63 0 1

7.4 2.51 3.00 2.40 0 2

11.0 2.40 1.00 3.71 1 2

9.9 2.36 1.00 3.66 0 1

12.3 2.47 1.00 4.33 1 2

9.1 2.30 1.00 2.28 0 2

7.4 2.36 1.00 2.35 0 2

8.8 2.18 2.00 2.49 0 1

10.6 2.51 1.00 3.15 1 2

12.4 2.83 1.00 3.42 1 1

9.2 2.40 1.00 2.31 0 1

11.3 2.52 1.00 4.33 1 1

9.9 2.67 1.00 3.04 0 1

6.4 2.36 1.00 2.47 0 1

10.8 2.61 1.00 4.09 1 1

7.7 2.86 1.00 2.88 0 1

14.6 2.93 2.00 4.94 1 1

13.0 3.14 1.00 5.04 1 2

11.4 2.31 2.00 5.30 1 1

7.3 2.25 1.00 2.24 0 2

9.6 2.25 2.00 3.02 0 1

11.2 2.30 1.00 4.23 1 1

7.7 2.56 1.00 2.67 0 2

11.9 2.55 1.00 3.65 1 1

15.3 2.68 1.00 5.63 1 1

10.7 2.79 1.00 4.30 1 1

9.1 2.48 1.00 3.33 0 2

10.3 2.80 2.00 4.06 1 1

10.2 2.15 1.00 2.82 1 1

10.2 2.34 1.00 3.82 1 1

8.8 2.65 1.00 4.06 0 1

8.1 2.24 2.00 3.47 0 2

11.9 2.59 1.00 3.69 1 2

8.9 2.29 1.00 3.01 0 1

13.8 3.01 1.00 5.08 1 1

9.1 2.39 2.00 3.13 0 1

8.9 2.39 1.00 4.39 0 2

7.9 2.68 1.00 2.73 0 1

11.2 2.55 1.00 4.66 1 1

11.4 2.12 1.00 4.26 1 1

9.2 2.24 1.00 4.08 0 1

10.8 2.60 2.00 3.78 1 1

9.0 2.09 2.00 3.04 0 1

12.4 2.63 1.00 4.24 1 2

13.0 2.59 2.00 4.65 1 1

13.6 2.85 2.00 4.57 1 1

7.4 2.39 1.00 1.16 0 1

8.0 2.44 1.00 2.39 0 1

12.4 2.59 2.00 4.18 1 2

9.4 2.40 1.00 3.05 0 1

14.0 2.46 1.00 5.58 1 1

10.3 2.33 1.00 3.93 1 1

9.6 2.32 1.00 2.73 0 2

12.6 2.69 1.00 3.55 1 1

10.8 2.47 1.00 3.97 1 3

9.9 2.60 1.00 3.35 0 2

11.5 2.47 1.00 3.35 1 2

7.2 2.66 1.00 2.80 0 1

12.6 3.04 1.00 3.60 1 2

6.9 2.33 1.00 1.57 0 1

8.6 2.26 1.00 2.79 0 2

10.3 2.72 2.00 3.86 1 1

10.5 2.63 2.00 2.64 1 1

9.9 2.71 1.00 4.20 0 1

7.6 2.69 2.00 2.00 0 1

11.2 2.49 1.00 4.14 1 2

13.0 2.24 1.00 5.08 1 2

12.0 2.57 3.00 3.61 1 2

10.2 2.74 1.00 3.41 1 1

12.3 2.86 2.00 4.94 1 1

6.9 2.13 1.00 1.61 0 1

12.0 2.63 2.00 4.75 1 1

12.1 2.58 1.00 5.38 1 2

11.1 2.66 1.00 4.40 1 1

12.8 2.71 1.00 4.99 1 1

11.3 2.67 1.00 3.74 1 3

9.6 2.09 2.00 4.48 0 2

11.4 2.57 1.00 4.59 1 1

7.1 2.16 1.00 1.06 0 1

10.8 2.26 1.00 3.37 1 2

8.3 2.21 2.00 2.99 0 1

6.0 2.32 2.00 2.14 0 1

9.0 2.20 2.00 3.37 0 2

10.1 2.31 1.00 4.38 1 1

11.8 2.20 1.00 3.77 1 2

10.1 2.32 1.00 3.03 1 3

9.2 2.56 1.00 2.99 0 2

10.2 2.29 1.00 3.93 1 1

10.0 2.17 1.00 3.77 0 1

7.9 2.26 2.00 3.10 0 2

10.9 2.69 1.00 3.97 1 1

9.6 2.50 1.00 3.34 0 2

9.4 2.63 1.00 3.11 0 2

11.1 2.72 2.00 3.92 1 1

10.0 2.91 2.00 4.26 1 1

10.2 2.56 1.00 2.36 1 2

12.0 2.61 2.00 4.58 1 2

9.4 2.78 1.00 3.73 0 2

On the next tab you will find data the the following variables Tasks to complete assignment on the next tab Y Price - Fare on a rideshare (Uber, Lyft....) YOU DO NOT NEED TO RUN REDUCED MODELS AS I ILLUSTRATED IN THE XLMiner VIDEO X1 Fuel - Fuel Price at the time 1. Determine the means and standard deviations for the Ride Share data X2 Weather - Weather conditions at the time - Clear=3, Fog=2, Wet=1 2. Present the Correlation Table for the Ride Share data X3 Distance - Distance in miles 3. Develop the (full) Multiple Regression model of Price against Fuel, X4 Traffic Load - Hi/Lo traffic periods - Hi=1, Lo=0 (binary) Weather, Distance, Traffic Load and Passengers X5 Passengers - Number of Passenger on trip 4. Complete the items on the left Interpret each regression coefficent relative trip price For example, each additional passenger (Increases, Decreases) trip price by xx.xx Fuel Weather Distance Traffic Load Passengers Present your Full Model Rsq Standard error Best predictor of Trip price Weakest predictor of price Are the regression coeficents in the direction you would expect (Y/N) For example, one might expect increases in fuel prices will increase trip prices - Yes Fuel (Y/N) Weather (Y/N) Distance (Y/N) Traffic Load Passengers