Basic Statistics and Linear Equations 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 Sales 145 492 319 265 389...

will attach at message


Basic Statistics and Linear Equations 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 Sales 145 492 319 265 389 321 180 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 Sales 295 218 374 365 281 234 304 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 Sales 248 482 341 174 482 310 273 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 Sales 314 285 158 482 284 310 281 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 401 385 291 317 330 281 274 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)⋅(q4)Lq=(n+1)⋅(q4) 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 Sales 248 482 341 174 456 310 273 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 314 285 158 482 284 310 281 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 132 284 271 469 143 175 230 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 145 492 319 265 389 321 180 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: Period 1 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: Period 1 2 3 4 5 6 7 Stock X 7% 1% -2% -3% 5% 11% 5% What is the (population) variance of the data? Please round your answer to six decimal places. Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel. Linear Combinations 1. Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 4% 7% -2% 40% 0% 10% -1% Stock Y 2% -5% 7% 4% 6% 11% -4% What is the correlation of returns on the two stocks? 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. 2. Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X -5% 4% 3% 9% 1% -3% 4% Stock Y 12% 7% -3% -2% 4% 6% -1% Consider a portfolio of 60% stock X and 40% stock Y. What is the mean of portfolio returns? Please specify your answer in decimal terms and round your answer to the nearest thousandth (e.g., enter 12.3 percent as 0.123). 3. Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 9% 5% 6% -2% 1% -3% 11% Stock Y -4% 3% 10% 7% 5% -3% 2% Consider a portfolio of 40% stock X and 60% stock Y. What is the (population) standard deviation of portfolio returns? 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. 4. Summary statistics for returns on two stocks X and Y are listed below. Mean Variance Stock X 4.86% 0.004000 Stock Y 3.96% 0.003000 The covariance of returns on stocks X and Y is 0.001100. Consider a portfolio of 80% stock X and 20% stock Y. What is the mean of portfolio returns? Please specify your answer in decimal terms and round your answer to the nearest thousandth (e.g., enter 12.3 percent as 0.123). 5. Summary statistics for returns on two stocks X and Y are listed below. Mean Variance Stock X 3.41% 0.003000 Stock Y 5.25% 0.004000 The covariance of returns on stocks X and Y is 0.001800. Consider a portfolio of 20% stock X and 80% stock Y. What is the variance of portfolio returns? Please round your answer to six decimal places. Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.