Explore BrainMass

Explore BrainMass

    Beta Technologies, Inc. Employee Salary Structure: regression analysis

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I need help with estimate simple linear regression model for the management of Beta Technologies, Inc. is trying to determine the variable that best explains the variation of employee salaries using a simple of 52 full time employees in the attached file. I need to identify which of the following has the strongest linear relationship with annual salary.

    Gender Age Prior_Experience Beta_Experience Education Annual_Salary
    1 39 5 12 4 $38,450
    0 44 12 8 6 $50,912
    0 24 0 2 4 $29,356
    1 25 2 1 4 $27,750
    0 56 5 25 8 $109,285
    1 41 9 10 4 $48,442
    1 33 6 2 6 $40,207
    0 37 11 6 4 $42,331
    1 51 12 16 6 $87,489
    0 23 0 1 4 $26,118
    0 31 5 4 6 $41,956
    1 27 0 8 0 $17,439
    0 47 11 9 4 $49,638
    1 35 5 5 6 $43,184
    1 29 5 4 0 $14,371
    0 46 4 15 6 $54,613
    1 50 10 17 4 $76,927
    0 30 3 6 4 $38,556
    1 34 10 1 4 $37,183
    1 42 11 8 4 $50,712
    1 51 10 15 8 $90,473
    0 63 16 20 4 $93,588
    0 28 0 5 4 $36,901
    1 32 4 1 4 $33,100
    0 55 11 16 6 $89,867
    1 45 20 2 4 $51,259
    0 34 2 12 2 $19,106
    0 33 2 7 4 $39,224
    1 23 0 1 4 $28,743
    0 40 4 13 6 $54,965
    1 48 6 15 4 $53,388
    1 27 0 6 0 $18,014
    1 36 5 5 6 $39,205
    0 58 9 22 4 $88,763
    0 31 1 1 6 $35,829
    1 21 0 1 2 $17,784
    0 47 5 16 4 $54,199
    1 35 3 7 4 $36,932
    1 52 12 14 8 $93,278
    0 29 3 3 2 $22,100
    1 42 11 7 4 $49,987
    0 60 10 21 4 $85,471
    1 50 8 13 4 $51,194
    1 33 1 2 6 $36,109
    0 26 0 5 2 $21,750
    0 38 6 6 6 $39,455
    1 44 7 12 4 $49,861
    0 25 0 3 4 $30,327
    1 37 8 5 4 $31,008
    0 53 13 13 6 $90,874
    0 46 7 18 4 $57,966
    1 20 0 1 0 $15,945

    © BrainMass Inc. brainmass.com June 3, 2020, 9:27 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/beta-technologies-inc-employee-salary-structure-regression-analysis-182788

    Attachments

    Solution Preview

    Please find attached response to your question.

    The regression analysis is present in the "Regression" Tab.

    Results of multiple regression for Annual_Salary

    Summary measures
    Multiple R 0.9501
    R-Square 0.9027
    Adj R-Square 0.8922
    StErr ...

    Solution Summary

    The solution presents regression analysis to determine which variable has the most influence in determining salary. A conclusion is stated.

    $2.19

    ADVERTISEMENT