The 289 patient records in the data for this case are for normal deliveries of babies. DAYS is the number of days ...

        Being sure that analyses of physician performance data are fair   and balanced is important in any such performance review. The 289 patient   records in the data for this case are for normal deliveries of babies. DAYS   is the number of days the patient spent in the hospital, CHRGS is the total   expenses charged to that patient, PHYS is a code identifying the physician,   and PAYOR indicates the type of insurance the patient carried: 1 for managed   care insurance and 0 for commercial insurance. Other things being equal, do   there appear to be any substantial differences in charges among the various   physicians? Write a brief report summarizing your findings.          VARIABLE   MEANING      DAYS is the   number of days the patient spent in the hospital.   CHRGS is the   total expenses charged to that patient    PHYS is a   code identifying the physician     PAYOR   indicated the type of insurance the patient carried:    1 for   managed care and 0 for commercial insurance.           DAYS (x1) PHYS (x2) PAYOR (x3) CHRGS (y)     2 10 0 1701    2 4 1 3500    2 10 0 3165    1 14 1 1953    2 2 1 2607    2 12 1 2944    4 2 1 5063    2 13 1 2396    4 2 1 4903    2 7 1 2280    2 7 1 2939    3 4 1 3585    2 13 1 3073    2 14 1 2880    2 10 0 2358    3 2 1 3418    3 2 0 3604    3 6 1 3480    2 10 0 3306    3 4 1 3047    2 11 1 2157    2 4 1 2439    3 11 1 2647    2 6 1 1874    1 10 1 2139    2 14 1 2424    2 12 1 2450    2 14 0 2198    2 10 1 3355    2 4 0 2609    2 2 1 2324    2 12 1 2207    2 11 0 2649    3 10 1 3375    2 6 1 3906    3 14 1 4049    2 13 1 2564    2 11 1 2745    3 6 1 1254    2 2 1 2953    2 7 1 2334    2 7 1 2809    2 13 1 929    3 14 1 3464    2 10 0 3173    2 14 1 3034    2 12 1 3716    2 6 1 2137    3 6 1 3430    3 6 1 3041    2 12 1 2247    3 12 1 4357    2 12 1 3050    2 12 1 2779    2 4 1 2357    2 7 1 2620    3 13 1 3369    2 7 1 3090    4 11 1 6340    2 10 1 2900    3 2 1 3709    3 4 1 3503    2 12 1 2991    2 14 1 2941    2 14 1 2668    2 2 1 2138    2 12 0 2227    2 10 0 2838    2 2 0 2681    3 7 1 3945    2 4 0 2026    3 10 1 3160    2 12 0 3270    3 6 1 4146    2 11 1 3757    2 7 1 2435    2 10 1 2343    3 2 1 3932    2 10 1 2285    2 14 1 3001    2 7 0 1864    3 12 1 4711    3 2 0 3283    2 7 1 2592    1 12 1 2081    1 14 1 1791    2 2 1 3729    2 10 1 2117    3 11 1 4510    2 7 1 2017    2 14 1 3118    3 2 1 3392    2 4 1 1854    14 2 1 14898    3 2 1 3819    3 4 1 2644    3 13 0 2331    3 11 1 3492    2 7 0 2666    3 2 1 4248    3 4 1 2500    2 10 1 3112    3 7 1 2955    2 14 1 2761    2 2 1 1905    3 10 1 3394    2 10 1 3663    3 6 1 3059    2 10 1 2528    2 2 1 2823    6 11 1 6710    2 13 1 2543    3 2 0 2785    2 12 0 2589    2 11 1 3183    1 10 1 1806    2 10 0 3115    2 7 1 3204    2 2 0 2921    3 2 0 4933    2 13 1 4722    3 13 1 5633    2 10 0 2780    2 4 1 2798    3 7 1 2066    3 11 1 2494    3 10 0 2724    2 11 0 2352    1 7 1 1793    2 4 1 2629    2 14 0 3094    2 2 0 2804    2 13 0 2801    2 7 1 2638    2 10 0 2263    2 11 0 2449    2 11 0 2473    3 6 1 2864    2 11 1 2534    2 10 1 2550    2 12 1 3768    2 10 0 3194    1 12 0 2153    1 7 0 1840    2 12 1 2522    1 12 1 2145    2 6 1 2403    3 2 1 3287    2 6 1 2979    2 7 0 3182    2 10 0 2954    2 11 0 2158    2 12 0 3455    2 14 1 2367    3 10 1 2798    2 11 1 2408    2 11 1 2468    3 12 1 3081    2 7 1 2218    3 11 0 2133    4 13 1 5499    2 12 1 2251    2 11 0 2310    1 11 0 2220    2 10 0 2176    1 2 1 2048    2 11 1 2566    2 11 0 2450    2 11 1 2582    2 7 0 2612    2 6 1 2683    2 14 0 2827    2 10 1 3202    3 10 1 3779    2 12 1 2833    2 10 0 3458    1 7 1 2789    2 7 1 1590    3 7 1 3868    2 12 1 3077    2 10 0 3109    3 4 0 2697    2 13 1 3182    2 6 1 3034    1 14 1 2179    1 7 1 2178    3 11 1 4185    2 10 1 1567    2 14 1 2347    1 10 1 2268    3 2 0 3617    2 10 1 2858    2 10 1 2542    2 7 1 2665    2 6 1 2436    2 12 1 2392    2 7 0 2739    3 12 0 2181    2 4 0 2308    2 13 0 3800    2 12 1 2242    2 7 1 2314    1 6 0 1960    3 11 1 4183    1 4 1 1663    1 7 0 2070    3 6 1 2753    3 6 0 2209    3 10 1 3218    2 13 0 2419    3 11 0 3289    2 4 1 2222    1 4 0 2741    3 10 1 3454    2 10 1 3848    2 7 0 2292    2 7 1 2594    2 6 1 2378    1 7 0 902    3 7 1 2935    2 6 1 3230    2 2 0 2219    3 12 1 2687    2 14 1 1848    3 4 0 2891    2 12 0 2698    2 7 0 3032    1 10 1 2886    1 2 0 3381    2 10 0 2752    1 13 1 3675    2 13 1 2840    2 13 0 3105    2 11 1 2288    2 14 0 3128    2 7 0 2289    2 10 0 2602    2 14 1 2604    2 12 0 1023    1 10 0 1899    2 10 1 2334    2 2 1 2310    3 6 1 3636    2 7 0 4206    2 12 1 2414    2 13 1 2206    3 2 1 2907    2 14 1 3017    2 14 1 3050    2 7 1 1973    2 10 1 2692    3 11 0 2564    2 10 1 3693    2 13 1 2741    2 2 1 2888    2 6 0 3279    3 7 1 2873    2 10 1 2582    2 2 0 2640    1 14 1 2068    2 10 0 2123    3 14 1 3480    3 6 0 4475    2 14 1 2312    2 4 1 2898    3 10 0 3708    1 10 0 2078    2 11 1 2570    3 14 1 3639    2 12 0 4674    2 14 0 2534    2 7 0 2797    2 12 0 3139    3 2 0 3826    2 10 0 2067    2 2 1 2840    2 12 1 2465    1 12 0 1947    1 7 0 2167    2 10 0 2840    2 6 1 2711    2 2 0 3137    1 2 0 2955    2 10 1 2563    1 4 1 1924    1 6 0 2062    2 13 0 2663    1 2 0 2184    2 10 1 3064     

     Provide the following   1. Excel output with three variables, with discussion   2. Excel output with only significant   variables   3. Scatter plot of each significant   independent with the dependent variable.   4. The multiple regression equation, with   discussion    5. S, with explanation   6. Adjusted R squared, with explanation   7. Global F, associated p-value, with   explanation   8. Confidence interval for   regression coefficients, in units of the variables, with explanation.   9. For given x values, the   "confidence interval", with explanation   10. For given x values, the   "prediction interval", with explanation