Create a SCATTER PLOT that illustrates how Sale_amount(Y) is influenced by Beds (X)

What proportion of variability in Sale_amount is explained by the model ?

What is the predicted Sale_amount for a house having Beds=4?

What is the residual for the house in the previous question, given that its Sale_amount = $320,571?

Determine the P value and conclusion for the coefficient of Beds Using significance level 10%

Beds: 4, 3, 4, 3, 3, 3, 4, 4, 4, 9, 5, 2, 3, 2, 4, 4, 3, 4, 4, 2, 3, 4, 3, 2, 4, 3, 4, 4, 4, 3, 5, 2, 3, 3, 3, 3, 3, 3, 4, 2, 3, 4, 2, 3, 4, 4, 3, 2, 4, 3, 4, 3, 2, 4, 4, 3, 5, 3, 2, 3, 3, 3, 3, 2, 5, 2, 3, 3, 5, 4, 4, 5, 3, 6, 5

Sqft Home: 2600, 1832, 2970, 1643, 3259, 1742, 2730, 2848, 2528, 4131, 1746, 1827, 2129, 720, 1561, 2744, 1504, 1774, 1785, 1259, 1148, 2624, 1343, 1552, 2006, 1356, 2763, 2495, 2600, 1895, 4013, 809, 1638, 1436, 1827, 1440, 1189, 2007, 1924, 1012, 2798, 1882, 1306, 3133, 4000, 2655, 1453, 728, 1872, 1482, 2202, 1670, 910, 1906, 1709, 1654, 2701, 1243, 1102, 2534, 1259, 1720, 1586, 1092, 3087, 1274, 1028, 1628, 3945, 1797, 2535, 2465, 2758, 4699, 2692

Sale Amount: $538,500, $238,000, $175,000, $1,125,000, $858,000, $135,000, $374,900, $285,000, $499,245, $115,100, $175,000, $145,000, $324,000, $121,000, $330,000, $475,000, $198,000, $1,480,000, $213,719, $117,500, $132,000, $171,500, $141,000, $325,000, $295,000, $217,000, $405,000, $235,000, $395,000, $140,000, $1,000,000, $275,000, $224,900, $217,750, $230,000, $205,000, $200,000, $175,000, $240,000, $178,500, $320,000, $115,000, $204,900, $555,000, $418,000, $430,000, $146,000, $184,719, $185,000, $232,900, $360,000, $499,000, $190,000, $330,000, $180,900, $200,519, $362,500, $92,000, $165,000, $272,500, $139,000, $300,000, $180,000, $168,000, $334,000, $213,000, $134,000, $229,000, $400,000, $195,000, $1,015,000, $299,500, $223,000, $650,000, $322,340.

Provide me with ALL of the excel functions ex: alpha, labels, regression, and ALL THE WORK DONE

Explain every step done in detail please