Question

In: Statistics and Probability

1.00 1.00 2.00 2.00 3.00 1.30 4.00 3.75 5.00 2.25 Make a scatterplot and include here...

1.00

1.00

2.00

2.00

3.00

1.30

4.00

3.75

5.00

2.25

Make a scatterplot and include here

Calculate the regression line.

Solutions

Expert Solution

By using excel we can solve this question easily.

We have to find a scatter plot

-First, enter all data into excel

Select all data ----------> Click on Insert --------> Scatter ------->Click on first graph
And then add a linear trendline.

We get


Related Solutions

Prob. Ret(A) Ret(B) 10% -5.00% -2.00% 20% 0.00% 1.00% 40% 5.00% 3.00% 20% 10.00% 4.00% 10%...
Prob. Ret(A) Ret(B) 10% -5.00% -2.00% 20% 0.00% 1.00% 40% 5.00% 3.00% 20% 10.00% 4.00% 10% 15.00% 5.00% 1) Please calculate covariance and correlation between A and B. 2) Please calculate the variance of a portfolio consisting of 45% of A and 55% of B. 3) Please find the MVP based on a portfolio consisting of A and B. What is the expected return of the MVP? What is the risk for the MVP? 4) Please find the optimal portfolio...
def main(): FISH_TACOS = 3.00 TACOS_AL_CARBON = 4.00 DON_PEDRO_SPECIAL = 9.00 PAPAS_CON_CHORIZO = 5.00 CARNE_ASADA_TACOS =...
def main(): FISH_TACOS = 3.00 TACOS_AL_CARBON = 4.00 DON_PEDRO_SPECIAL = 9.00 PAPAS_CON_CHORIZO = 5.00 CARNE_ASADA_TACOS = 1.75 SALES_TAX = 0.06 DISCOUNT = 0.1 costofFish_Tacos=.0 costofTacos_Al_Carbon=.0 costofDon_Pedro_Special=.0 costofPapas_Con_Chorizo=.0 costofCarne_Asada_Tacos=.0 numofFish_Tacos=.0 numofTacos_Al_Carbon=.0 numofDon_Pedro_Special=.0 numofPapas_Con_Chorizo=.0 numofCarne_Asada_Tacos=.0 subTotal=.0 AmountGiven=.0 cash = .0 change = .0 OrigTotal=.0 WithTax=.0 TotalOrder = .0 AmountGiven = .0 numofFish_Tacos,numofTacos_Al_Carbon,numofDon_Pedro_Special,numofPapas_Con_Chorizo,numofCarne_Asada_Tacos= getInput() getOutput(FISH_TACOS,TACOS_AL_CARBON,DON_PEDRO_SPECIAL,PAPAS_CON_CHORIZO,CARNE_ASADA_TACOS,numofFish_Tacos,numofTacos_Al_Carbon,numofDon_Pedro_Special,numofPapas_Con_Chorizo,numofCarne_Asada_Tacos) subTotal = calcOrder(FISH_TACOS,TACOS_AL_CARBON,DON_PEDRO_SPECIAL,PAPAS_CON_CHORIZO,CARNE_ASADA_TACOS,numofFish_Tacos,numofTacos_Al_Carbon,numofDon_Pedro_Special,numofPapas_Con_Chorizo,numofCarne_Asada_Tacos) WithTax = CalcTax(subTotal,SALES_TAX) disTotal(subTotal, WithTax) CalcCash(OrigTotal, cash, change) def getInput(): numofFish_Tacos = int(input("How many Fish Tacos do you want?")) numofTacos_Al_Carbon = int(input("How many Tacos Al...
A student mixes 5.00 mL of 2.00 x 10-3 M Fe(NO3)3, 4.00 mL of 2.00 x...
A student mixes 5.00 mL of 2.00 x 10-3 M Fe(NO3)3, 4.00 mL of 2.00 x 10-3 M KSCN, and 1.00 mL of distilled water and finds that in the equilibrium mixture, the concentration of FeSCN2+ is 1.31 x 10-4 M. The equation describing the equilibrium is Fe3+ (aq) + SCN- (aq) →← →← FeSCN2+ (aq) Calculate the concentration of FeSCN2+ at equilibrium. Include appropriate significant figures and units in your response. Example input: 1.31x10^-4 M.
Income ($1000s) Household Size Amount Charged ($) 89.31 2.00 10985.47 61.08 5.00 9792.97 43.95 4.00 6527.55...
Income ($1000s) Household Size Amount Charged ($) 89.31 2.00 10985.47 61.08 5.00 9792.97 43.95 4.00 6527.55 55.15 6.00 9708.57 40.39 2.00 6335.20 34.06 3.00 4809.57 86.43 4.00 12314.59 79.49 3.00 10823.38 48.40 2.00 7172.03 46.49 3.00 6996.39 50.68 3.00 7349.23 73.77 5.00 11719.66 34.18 4.00 6062.71 81.64 3.00 9861.66 65.08 4.00 10411.15 41.96 3.00 8169.33 41.48 2.00 6705.15 45.21 3.00 5871.21 48.98 5.00 8627.18 35.70 4.00 6466.99 77.36 2.00 9646.36 79.00 3.00 11910.64 52.03 3.00 7624.06 42.91 3.00 7635.68 38.69...
CategoryNumber (in millions) Unemployed 5.00 Unemployed more than 27 weeks 1.00 Fictionally unemployed 2.00 Cyclically unemployed...
CategoryNumber (in millions) Unemployed 5.00 Unemployed more than 27 weeks 1.00 Fictionally unemployed 2.00 Cyclically unemployed 1.25 Discouraged workers 1.00 Workers who are part time but want full time work 3.00 Marginally attached workers 5.00 Employed 120 Population aged 16 and above 250 Total population 300 _________ What is the U-3 unemployment rate (i.e., the "headline" rate, which is what you see most often)? _________ What is the U-6 unemployment rate? That is, the "broad" measure of unemployment, or sometimes...
Year Stock X Stock Y 1 12.00% 10.00% 2 4.00% 18.00% 3 15.00% 2.00% 4 1.00%...
Year Stock X Stock Y 1 12.00% 10.00% 2 4.00% 18.00% 3 15.00% 2.00% 4 1.00% 8.00% What is the covariance of the returns of Stock X with the returns of Stock Y?" Please round to 6 decimal places, the answer should be negative. Thanks
make a tree for the Chordates – include changes here too
make a tree for the Chordates – include changes here too
Complete the Vec class to make it similar to the vector. sample code here. #include #include...
Complete the Vec class to make it similar to the vector. sample code here. #include #include #include #include #include using namespace std; int get_mode( vector vec ) { int numbers[101] = {0}; for ( int e : vec ) numbers[e]++; int greatest = 0, n = 0; for ( int i = 0; i <= 100; i++ ) { if ( numbers[i] > greatest ) { greatest = numbers[i]; n = i; } } return n; } const double g...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT