Question
statistics questions need help with the following attached file please 1. Unit sales for new product ABC have varied in the first seven months of
statistics questions need help with the following attached file please
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 385 419 227 193 283 137 419 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 248 482 341 174 456 310 273 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 132 284 271 469 284 175 230 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 401 385 291 317 330 281 274 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 formula Lq = (n+1)*(q/4) to find quartile locations. 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 314 285 158 482 284 310 281 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 248 482 341 174 456 310 273 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 401 385 291 317 330 281 274 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 330 274 492 371 160 283 164 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 8% 0% 3% -2% 5% 12% 7% 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 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. LINEAR COMBINATIONS: PART 1: 1. Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 9% 6% 1% 8% -1% 3% 10% Stock Y -2% 9% 5% 12% -1% 6% 5% 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 4% -2% 5% -1% 10% 7% 12% Stock Y -3% 7% 4% 2% 2% 8% -3% Consider a portfolio of 10% stock X and 90% 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 5.81% 0.004000 Stock Y 3.11% 0.007000 The covariance of returns on stocks X and Y is 0.002100. Consider a portfolio of 10% stock X and 90% 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 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 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. LINEAR COMBINATIONS: PART 2: 1. Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 7% 1% -2% -3% 5% 11% 5% Stock Y -4% 10% 4% 8% 7% -1% -3% What is the (population) covariance of returns on the two stocks? 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. 2. Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 9% 6% 1% 8% -1% 3% 10% Stock Y -2% 9% 5% 12% -1% 6% 5% 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). 3. Returns on stocks X and Y are listed below: Period 1 2 3 4 5 6 7 Stock X 4% -2% 5% -1% 10% 7% 12% Stock Y -3% 7% 4% 2% 2% 8% -3% Consider a portfolio of 10% stock X and 90% stock Y. What is the (population) 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. 4. Summary statistics for returns on two stocks X and Y are listed below. Mean Variance Stock X 2.71% 0.003000 Stock Y 3.16% 0.005000 The covariance of returns on stocks X and Y is 0.003900. Consider a portfolio of 70% stock X and 30% 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 5.81% 0.004000 Stock Y 3.11% 0.007000 The covariance of returns on stocks X and Y is 0.002100. Consider a portfolio of 10% stock X and 90% 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. PROBABILITY PART 1: 1. A corporation produces packages of paper clips. The number of clips per package varies, as indicated below for a sample of 20 packages. 51 50 48 49 53 50 49 47 50 51 49 50 47 48 52 48 47 50 49 52 Create a histogram. How many packages contain between 47 and 51 clips (inclusive) per package? Please specify your answer as an integer. 2. A corporation produces packages of paper clips. The number of clips per package varies, as indicated below for a sample of 20 packages. 53 50 51 48 47 50 52 48 50 51 52 48 49 52 50 51 47 49 53 49 Create a probability density function. What is the probability that a randomly chosen package contains between 49 and 53 clips (inclusive) per package? Please specify your answer in decimal terms and round your answer to the nearest hundredth (e.g., enter 12 percent as 0.12). 3. Let X be a discrete random variable. If Pr(X8) = 1/5, then what is Pr(X=8)? Please specify your answer in decimal terms and round your answer to the nearest hundredth (e.g., enter 12 percent as 0.12). 4. Let X be a discrete random variable. If Pr(X6) = 1/7, then what is Pr(X=6)? Please specify your answer in decimal terms and round your answer to the nearest hundredth (e.g., enter 12 percent as 0.12). 4. Let X be a discrete random variable. If Pr(X# }`h####PK##########!#}############_rels/.rels ##(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ ################################################################################ #######################################J#1##! }7*"loD#c2#9LmZ#{99,W{7wJ#`^ `#O{###'##j/4"%3W'R###? #$r{yN~:#|rdKl7##C##) V ##s[-# v #y#Hy#kRoh5i)X~'#L6v} v $*#[ ^`M###or %7nT_|+R"#:{f #!##A##6 qN#####@#1d###!#p#BN#J#!%p&]{@ #& Un##a##)O?L}}g ) O)F0yX9>e~#u#.{x q # ln#:{#(K33NC E|nQK#@#G! ####I##:1w;#zPF#Verl7###| QVRg7##37'##/#kkst+W##n=&t>pzB~0dBz#m #K#O ~/4(M-55Ui@2 'g%##Rel#PRRL#@#rl{J#Ed#`#B\\zN8}^V=o=|! #o=Z ? x#&_^###'n #v6#8G#.N=q~G#z$P#k'>lE#V#= 8Vo#I1W#### nD#q^ %3W'R###? #$r{yN~:#|rdKl7##C##) V ##s[-# v #y#Hy#kRoh5i)X~'#L6v} v $*#[ ^`M###or %7nT_|+R"#:{f #!##A##6 qN#####@#1d###!#p#BN#J#!%p&]{@ #& Un##a##)O?L}}g ) O)F0yX9>e~#u#.{x q # ln#:{#(K33NC E|nQK#@#G! ####I##:1w;#zPF#Verl7###| QVRg7##37'##/#kkst+W##n=&t>pzB~0dBz#m #K#O ~/4(M-55Ui@2 'g%##Rel#PRRL#@#rl{J#Ed#`#B\\zN8}^V=o=|! #o=Z ? x#&_^###'n #v6#8G#.N=q~G#z$P#k'>lE#V#= 8Vo#I1W#### nD#q^
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started