PLEASE HELP ME UNDERSTAND AND SOLVE ALL EQUATIONS IN EXCEL ONLY. PLEASE INCLUDE PROPER FORMULAS FOR CORRECT ANSWERS. THANK YOU.

1:Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales248 482 341 174 456 310 273

What is the mean of the data?

Please round your answer to the nearest integer.

2.Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales314 285 158 482 284 310 281

What is the median of the data?

Please specify your answer as an integer.

3.Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales330 274 492 371 274 283 164

What is the mode of the data?

Please specify your answer as an integer.

4.Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales330 274 492 371 160 283 164

What is the range of the data?

Please specify your answer as an integer.

5.Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales 385 419 227 193 283 137 419

What is the interquartile range (IQR) of the data?

Please specify your answer as an integer.

Note: Use the following formula to find quartile locations:

Lq=(n+1)(q/4)

where q is the quartile index (e.g., q=1 for the first quartile) and n is the number of data points.

Excel's QUARTILE (and PERCENTILE) function uses a different method to compute quartile boundaries.

6.Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales145 492 319 265 389 321 180

What is the (population) variance of the data?

Please round your answer to the nearest integer.

Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.

7.Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales 330 274 492 371 160 283 164

What is the (population) standard deviation of the data?

Please round your answer to the nearest integer.

Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.

8.Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales 295 218 374 365 281 234 304

What is the (population) Pearson's coefficient of skewness of the data?

Please round your answer to the nearest hundredth.

Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.

9.Unit sales for new product ABC have varied in the first seven months of this year as follows:

Month Jan Feb Mar Apr May Jun Jul Unit Sales 314 285 158 482 284 310 281

What is the (sample) skewness of the data?

Please round your answer to the nearest hundredth.

Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.

10.Returns on stock X are listed below:

Period1 2 3 4 5 6 7 Stock X 7% 1% -2% -3% 5% 11% 5%

What is the mean of the data?

Please specify your answer in decimal terms and round your answer to the nearest thousandth (e.g., enter 12.3 percent as 0.123).

11.Returns on stock X are listed below:

Period1 2 3 4 5 6 7 Stock X 9% 6% 1% 8% -1% 3% 10%

What is the (population) standard deviation of the data?

Please specify your answer in decimal terms and round your answer to the nearest thousandth (e.g., enter 12.3 percent as 0.123).

Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.