Homework 3 Use the specific data provided for each problem. 1. Stocks Data: An investor portfolio seems to be underperforming. She was promised a portfolio that would ‘mirror’ the returns of the...

1 answer below »

Homework 3



Use the specific data provided for each problem.




1. Stocks Data: An investor portfolio seems to be underperforming. She was promised a portfolio that would ‘mirror’ the returns of the entire U.S. stock market. A sample of 39 monthly returns of her portfolio is provided (variable 1, stocks). Test to see if the portfolio did in fact provide the returns of the U.S. Stock market. Over the same 39 months, the S&P 500 had a monthly average return of .95%.



a. What are the sample mean and standard deviation for the portfolio?




b. What are the correct null and alternative hypotheses? Assume that a neutral


arbitration panel is conducting the test.




c. What are the results of the test?






d. How much different than the S&P was the portfolio? Use 95% confidence.



Cr



e. Should damages be awarded to the owner of the portfolio? If so, how would you approximate a fair amount?




2. Machine Capacity (variable 4): An engineering team is tasked with improving the maximum capacity of a recycling plant. The current average capacity is 33,000 pounds per hour. A sample of 90 hours was taken to test whether the changes were successful.



a. Are there any outliers in the data?


b. Using all 90 hours of data, test to see if the process was improved. State your results.


c. Estimate the machine capacity after the improvements. Use 95% confidence.


d. There are three compensation levels for the engineers: 1. Time only- if the changes were not successful, 2. Time plus standard fee- if the changes were successful at 5% level of significance, 3. Time, fee plus bonus- if improvements were highly significant (1% alpha). Which should the team be paid and why?



3. French language instruction: Using variables 2 and 3, consider the effectiveness of a French language instructional program. Your company uses the program to prepare executives for business in France. Each of the executives participating were given a pre test and, after the program, a post test.



a. What method is most useful to test the effectiveness of the program?


b. What are the test results?


c. What is your estimate of the average score change? Use 95% confidence.


d. If you were arguing in favor of keeping the program, what evidence could you sight from your test/estimate? If you wanted to cut the program funding, what evidence could you site?



4. Computer vs. Driver (variables 5 and 6): Many automobiles have computers that track average fuel economy. Fuel economy is major selling point. A consumer protection group is concerned that autos might overestimate the actual mileage and so an experiment to test the computer’s estimate is designed.



a. Test to see if the difference between the computer and the driver mileage numbers is highly significant. What are your results?


b. What is the average difference between the computer and the driver?


c. What is your estimate of the true average difference? Use 95% confidence.


d. Do you see any problem with the computer estimate of mileage? Is the difference, if any, explainable?




5. Image Priming: Image priming is used in advertising. If a consumer is ‘primed’ to see an image, they have a prior impression of what the image means, independently of the product being advertised with the image. (Think of a wine label with a picture of zebra- zebras have nothing to do with wine but an image of a zebra may be associated with a particular feeling. Or think of ad for lemonade that has a picture of front-porch swing). The effectiveness of an ad, in theory, should be improved if the target market is ‘primed’ to perceive images in a particular way.



A sample of 42 respondents answered Yes or No when asked if the image being used in an ad meant anything to them. Then they viewed an ad using that image. Then scored the effectiveness of the ad 1-5, 5 being best.



Test to see if the Yes group has a significantly higher average score than the No group. What are your results? What is your estimate of mean score difference? Use 95% confidence. Does image priming seem to work based on this experiment?



6. Gender and Survey of Study Habits and Attitudes (SSHA): Using the sample provided, consider the relationship between gender and SSHA score.



a. Check each sample carefully for any outliers/skew.


b. Test to see if there is a significant difference in average SSHA between genders. What are your results?


c. What do these results allow you to conclude?


d. What is the limitation of this study? In other words, what is the potential risk in generalizing your conclusion to the entire population of college students?

Answered Same DayFeb 24, 2021

Answer To: Homework 3 Use the specific data provided for each problem. 1. Stocks Data: An investor portfolio...

Rajeswari answered on Feb 24 2021
136 Votes
Data
        1    2    3    4    5    6    7    8    9    10        Analysis
        Stocks    French2    French1    Capacity    Comp    Driver    Primed    Score    Gender    Score
        -8.36    34    32    34646    41.5    36.5    No    3    Women    156        1-sample t
        1.63    31    31    37964    50.7    44.2    No    1    Women    109        Input Number     1
        -2.27    35    29    42604    36.6    37.2    No    5    Women    137
        -2.93    16    10    41002    37.3    35.6    No    3    Women    115         z -Test Proportion
        -2.7    33    30    38969    34.2    30.5    No    3    Women    152        Input Number
        -2.93    36    33    41328    45    40.5    No    4    Women    140        Category
        -9.14    24    22    38339    48    40    No    3    Women    154
        -2.64    28    25    32498    43.2    41    No    3    Women    178        Matched samples t
        6.82    26    32    39086    47.7    42.8    No    3    Women    111        Input Number
        -2.35    26    20    36
945    42.2    39.2    No    3    Women    123        Input Number
        -3.58    36    30    24573    43.2    38.8    No    1    Women    126
        6.13    26    20    36963    44.6    44.5    No    4    Women    126        2-sample t
        7    27    24    43818    48.4    45.4    No    3    Women    137        IV: Input Number
        -15.25    24    24    42708    46.4    45.3    No    3    Women    165        Input Category Labels
        -8.66    32    31    40935    46.8    45.7    No    2    Women    165            1
        -1.03    31    30    39947    39.2    34.2    No    3    Women    129            2
        -9.16    15    15    39863    37.3    35.2    No    3    Women    200        DV: Input Number
        -1.25    34    32    37341    43.5    39.8    No    3    Women    150
        -1.22    26    23    41844    44.3    44.9    No    4    Men    118        ANOVA
        -10.27    26    23    44686    43.3    47.5    No    2    Men    140        IV: Input Number
        -5.11            47003            Yes    3    Men    114        Input Category Labels
        -0.8            33642            Yes    3    Men    91            1
        -1.44            44295            Yes    5    Men    180            2
        1.28            40481            Yes    4    Men    115            3
        -0.65            41163            Yes    4    Men    126        DV: Input Number
        4.34            39805            Yes    4    Men    92
        12.22            41005            Yes    5    Men    169        Chi-Square Test
        -7.21            41002            Yes    5    Men    139        Row: Input Number
        -0.09            34680            Yes    4    Men    121        Input Category Labels
        7.34            40736            Yes    4    Men    132            1
        5.04            38458            Yes    2    Men    75            2
        -7.24            36009            Yes    5    Men    88            3
        -2.14            42383            Yes    4    Men    113            4
        -1.01            40424            Yes    5    Men    151            5
        -1.41            35480            Yes    4    Men    70        Col: Input Number
        12.03            41275            Yes    4    Men    115            1
        -2.56            34817            Yes    4    Men    187            2
        4.33            38121            Yes    5    Men    114            3
        2.35            35539            Yes    5                    4
                    32552            Yes    2                    5
                    31934            Yes    3
                    42004            Yes    4
                    40819
                    39022
                    39002
                    37490
                    28208
                    36351
                    42186
                    44946
                    32251
                    39051
                    34168
                    38089
                    40944
                    41384
                    36550
                    30070
                    36881
                    31693
                    31413
                    27206
                    39692
                    31934
                    27383
                    29155
                    31778
                    31861
                    38146
                    18020.7
                    13025.5
                    40069
                    37757.9
                    20160.3
                    19284.3
                    19586.8
                    18092
                    20167.1
                    20943.5
                    20135
                    27823
                    59074
                    49402
                    54633
                    46471
                    57395
                    41362
                    1500
                    2500
                    2000
z Test P
            Significance Test for Population Proportion (z-test)
                Sample Information
                Sample size n             Sample size n                         
                # of Successes (x)            # of Successes (x)                        ERROR:#VALUE!
                Sample Proportion            Sample Proportion                        
                Standard Error    
                                                        C.I. MOE
                Significance Test Results (z-test)
        
        
                (Assumed p) Ho: p =             Ha: p not =     
        
        
                Test Statistic ( z )            P-value (2-tail)    
                Critical Value (2-tail)            Significance (a)    5%
        
                Reject Null?    
        
                            
        
                
        
        
        
                Confidence Level    p-hat +/- z* (Std Error)                Confidence Interval
                95%        ±        =        
        
                                    Test Value for P    
        
                z * ( + / - )            Test Statistic ( z )    
                Std Error C.I.    
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
t Test
            Significance Test for Population Mean (t-test)
                Sample Information
        Stocks        Sample size n     39        Sample size n                         
        -8.36        Sample Mean x̅    -1.100        Sample Mean x̅                        ERROR:#VALUE!
        1.63        Standard Deviation s    5.991        Standard Deviation s                        39
        -2.27        Std Error    0.959
        -2.93
        -2.7        Significance Test Results (t-test)
        -2.93
        -9.14        (Test Value) Ho: m =              Ha: m not =     
        -2.64
        6.82        Test Statistic ( t )            P-value (2-tail)    
        -2.35        Critical Value 2-tail            Significance (a)    5%
        -3.58
        6.13        Reject Null?    
        7
        -15.25                    
        -8.66
        -1.03        
        -9.16
        -1.25
        -1.22        Confidence Level    x-bar        t * (Std Error)        Confidence Interval
        -10.27        95%    -1.100    ±    1.942    =    -3.04    0.84
        -5.11
        -0.8                            Test Value for m    
        -1.44
        1.28        t * ( + / - )    2.024        Test Stat ( t )    
        -0.65
        4.34
        12.22
        -7.21
        -0.09
        7.34
        5.04
        -7.24
        -2.14
        -1.01
        -1.41
        12.03
        -2.56
        4.33
        2.35
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
Matched
                    Matched Samples Test (t-test)
                        Sample Information
                Difference        Sample size n             Sample size n                         
                        Sample Mean x̅d            Sample Mean x̅d                        ERROR:#VALUE!
                        Std Dev sd            Std Dev sd                        
                        Std Error    
                
                        Significance Test Results (t-test)
                
                        Test Value md    0
                        Test Statistic t             P-value (2-tail)    
                        Critical Value 2-tail            Significance (a)    5%
                
                        Reject Null?    
                
                                    
                
                        
                
                
                        Confidence Level    x̅d        t * (Std Error)        Confidence Interval
                        95%        ±        =        
                
                                            Test Value md    
                
                        t * ( + / - )            Test Stat ( t...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here