It is realized that the Price ($) of commuting in a country depends on the age of the passenger, duration, and distance.

Age of the passenger	Duration (in minutes)	Distance (in miles)	Price (in $)
61	16	3.2	22.3
24	4	1.5	12.5
47	29	5	29
32	33	5.8	36.2
23	14	2.3	19.1
82	30	6.1	36.5
57	56	12	66.9
36	11	1.9	17.3
42	2	0.8	8
47	14	1.7	18
29	15	2.8	24.3
27	15	2.5	22.1
19	45	4.2	44.3
45	19	3.6	23
39	49	10.2	61.1

1. Copy the data in Excel and conduct a regression analysis [ Include all inputs/ independent variables. Do not exclude any inputs even if the p values are not significant (>0.05)]

Q) Take a snapshot of the summary output of regression that shows R square, coefficients for the intercept and the independent variables.

( I need a snapshot of the summary output of regression in Excel)

2. Remove the statistically insignificant input (p value > 0.05) from the dataset and rerun the regression again.

Q) If you are using Word file, take a snapshot of the summary output of regression that shows R square, coefficients for the intercept and the independent variables.

( I also need a snapshot of the summary output of regression in Excel)

Thank you.