statistics

profileclmttcsenl432
Home>Homework Answsers>Mathematics homework help>Algebra homework help
 NEWS has gathered data over the last 52 weeks. Two of the data items that have been gathered are Profit and the Number of Defective Items.  
                
 Question 1:  Using the data given below, complete Task 1 and provide a very brief, general description of whether or not a relationship exists  
 between Profit and the Number of Defective Items.            
 ANSWER:   
 
 
 Question 2:  Using the data given below, complete Task 2 and provide a statistical description of whether or not a relationship appears to exist  
 between Profit and the Number of Defective Items.            
 ANSWER:   
 
 
 
                
 Week Profit (thousands) Number of Defective Items              
           1 $           35.00974             
           2 $         490.00693  Task 1:  Create a Scatterplot          
           3 $         777.00248  Step 1. Highlight the two columns of data (Profit, Defective Units)       
           4 $         922.00277  Step 2. Click the Quick Analysis icon on the bottom right       
           5 $         519.00509  Step 3. Select Charts and Scatter         
           6 $         520.00635             
           7 $         899.00200  Place the Chart below this row          
           8 $         391.00743             
           9 $         577.00563             
        10 $         419.00715             
        11 $         667.00397             
        12 $         399.00720             
        13 $         540.00659             
        14 $         954.00123             
        15 $      1,078.008             
        16 $         563.00444             
        17 $         619.00464             
        18 $         625.00483             
        19 $         351.00715             
        20 $         674.00444             
        21 $         547.00639   Task 2:  Correlation and Regression Fitted Line        
        22 $         578.00503  Step 1. Place your mouse over any point within your scatterplot above and right click. Then select Add Trendline. 
        23 $         609.00565  Step 2. Select Linear, then scroll down and Display Equation and R squared Value on Chart    
        24 $         228.00785  Step 3. Place the values in a visible area of the chart so that they are legible and not covered by any of the data 
        25 $         871.00286             
        26 $         188.00842  Determine the Correlation Coefficient (R), using the CORREL function and highlighting each column (Profit, Defective). 
        27 $         632.00480  CORRELATION COEFFICIENT =          
        28 $         442.00721             
        29 $         442.00571  Check the Correlation Coefficient (R) by taking the square root (SQRT) of the R squared value in the chart above.  
        30 $      1,114.0025  Determine the sign (+ or -) of R based on the direction of the regression line.     
        31 $         864.00272             
        32 $         825.00241  CORRELATION COEFFICIENT =          
        33 $         750.00252             
        34 $         615.00500             
        35 $         445.00674             
        36 $         282.00732             
        37 $         409.00701             
        38 $         637.00401             
        39 $         646.00536             
        40 $         999.00156             
        41 $         232.00824             
        42 $         152.00964             
        43 $         874.00212             
        44 $         981.00218             
        45 $         289.00747             
        46 $         771.00356             
        47 $         806.00303             
        48 $         921.00113             
        49 $         150.00883             
        50 $         113.00910             
        51 $      1,084.0085             
        52 $         350.00745             
                
    • 10 years ago
    • 20
    Report issue
    Answer(1)
    profile
    WiseOne
    4.2 (16)
    5.0 (2)
    Chat

    Purchase the answer to view it

    blurred-text
    • attachment
      mba501_excel.xls