For the Excel file Closing Stock Prices, a. Apply both column and line sparklines to visualize the trends in the prices for each of the four stocks in the file. b. Compute the daily change in the Dow Jones index and apply a win/loss sparkline to visualize the daily up or down movement in the index. | Numerade

Descriptive statistics for the closing stock prices of two companies for several trading periods are shown below:Baba, Inc: Mean = 15.91, Standard Error = 0.29, Median = 16.59, Mode = 15.58, Standard Deviation = 3.21, Sample Variance = 10.331, Kurtosis = -2.09, Skewness = 13.45, Range = 2.03, Minimum = 18.99, Maximum = 1972.6, Count = 436.Maman, Inc: Mean = 4.00, Standard Error = 0, Median = 15.91, Mode = 0.08, Standard Deviation = 2.03, Sample Variance = 18.99, Kurtosis = 1972.6, Skewness = 436

SOLVED: 1. A random sample of the closing stock prices in dollars for acompany in a recent year is listed below. Assume that σ is 2.12.Construct the 90% and99% confidence intervals for the population mean. Interpret theresults and compare the widths of the confidence intervals.21.4521.6815.1320.9116.9816.5219.3722.7420.8718.7318.3218.3118.9319.1419.5218.212. Find the margin of error for the given values of c,σ,and n.c=0.90,σ=3.3,n=49Level of Confidencezc90%1.64595%1.9699%2.575