excel22 It has to be in 1 Excel workbook with the appropriate worksheets.

1 answer below »
it has to be done in excel


excel22 It has to be in 1 Excel workbook with the appropriate worksheets.
Answered Same DayNov 10, 2021

Answer To: excel22 It has to be in 1 Excel workbook with the appropriate worksheets.

Mohd answered on Nov 11 2021
121 Votes
data
    A    B    C    D
    1    2    5    9
    2    5    11    20
    3    7    14    31
    4    8    22    41
    5    9    25    48
    6    10    28    59
    7    20    34    68
    8    2
2    40    82
    9    26    51    90
    10    30    56    99
    Average    13.9    28.6    54.7
    Standard Deviation    9.7    16.8    30.3
    Median    9.5    26.5    53.5
Line Chart
Descriptives Over Groups
Average    13.9    28.6    54.7    Standard Deviation    9.7233967544497766    16.827226615088879    30.250987128062814    Median    9.5    26.5    53.5    
reg1
    A    B    C    D                                    SUMMARY OUTPUT
    1    2    5    9
    2    5    11    20                                    Regression Statistics
    3    7    14    31                                    Multiple R    0.974
    4    8    22    41                                    R Square    0.949
    5    9    25    48                                    Adjusted R Square    0.935
    6    10    28    59                                    Standard Error    2.486
    7    20    34    68                                    Observations    10
    8    22    40    82
    9    26    51    90                                    ANOVA
    10    30    56    99                                        df    SS    MS    F    Significance F
    Average    13.9    28.6    54.7                                    Regression    2    807.645    403.823    65.352    0.000
    Standard Deviation    9.7    16.8    30.3                                    Residual    7    43.255    6.179
    Median    9.5    26.5    53.5                                    Total    9    850.9
                                                        Coefficients    Standard Error    t Stat    P-value    Lower 95%    Upper 95%    Lower 95.0%    Upper...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here