1.Using Excel, give the average and standard deviation of the following set of numbers: {0.350, 0.117, 3.645, 0.948, 0.145, 3.392, 3.695, 1.426, 1.640, 0.814, 10.190, 1.486}. Then plot both the histogram, bucketing the data into 10 evenly spaced bins, and the fitted Gaussian of the latter data in the same spreadsheet, superimposed or overlaid on each other with the same x-axis, on the same printed page.

2.A combination of conductivity with standard addition was used to test the concentration of magnesium sulfate (Epsom Salt) in a hot water spring in Russia that claims healing powers because of the high salinity. The conductivity of the raw unprocessed sample from this spring measured 161.44 S/cm for an initial volume of 50.00 mL. Although conductivity is rather unspecific to the measurement of particular ions, standard addition of 5.00 mL increments of a 690 mM MgSO₄standard solution provided the following conductivity responses: [161.44, 203.51, 234.18, 267.48, 284.65, 338.06, 348.6] S/cm. Using Excel, compute and plot the [I_(s+x)*(V₀+V_s)/V₀)] vs. [S_i*V_s/V₀] data and fit the data using least-square line (aka linear regression via linest) fitting. Find the slope, y-intercept, and correlation coefficient (R²) and report the final concentration, in mM, of MgSO₄of the magical spring.