Purchase Solution

Create a Pivot Table of Management Level vs. Gender

Not what you're looking for?

Ask Custom Question

Using the Cumba database file, create a pivot table of management level versus gender. Then, copy the data from the table into a chi square table to see if a relationship exists between employee genders and their management level. What can you conclude at the .05 significance level?

Using the Cumba database file, develop a model to predict employee salary using employee age, years of experience, and gender. Since gender is nominal, use 0 for male and 1 for female. The Multiple Regression file has already been pre-loaded with the data, so you need only interpret the output. Complete the following tasks:
State the multiple regression equation.

Interpret the meaning of the slopes in the equation.
Predict the salary for a 40-year-old male employee with 5 years of experience.
At the .05 level of significance, determine whether each explanatory variable makes a significant contribution to the regression model.
Interpret the meaning of the r-squared.
Interpret your findings. What changes would you make to the model, given the results?

Purchase this Solution
Solution Summary

The solution creates a pivot table of management level vs. gender.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • What can you conclude at the .05 significance level?

    373203 Statistics: Create a pivot table of management level versus gender Use the cumba file attached and show work in Excel. .Using the Cumba database file, create a pivot table of management level versus gender.

  • Chi-square, Correlation, Multiple Regression

    Using the 'Cumba' database file, create a pivot table of management level versus gender. Then copy the data from the table into a chi square table to see if a relationship exists between employee genders and their management level.

  • Pivot Table Record In Excel

    In this solution we create a pivot table record in Excel.

  • Pivot Table and Chi Square Hypothesis Test

    305852 Pivot Table and Chi Square Hypothesis Test Using the "Cumba" database file, create a pivot table of management level versus gender.

  • Pivot Table

    Compile a pivot table that gives a tabulation of sales (in cases) by brand (Dove, Sunlight etc.) b. Compile a pivot table that gives a tabulation of sales broken down by brand and by week. c.

  • Pivot table and "IF" function

    Make a copy of the home Sale data worksheet and rename it worksheet q5. 6) Create a pivot table ("Insert" pivot table) to show the number of homes sold, average, highest, and lowest sale price for each of the three types of homes: Condo, Ranch and Victorian

  • Performing Statistical Analysis with Pivot Table

    Keep bar chart as part of your answer (5 pts) PELICAN STORES Pelican Stores, a division of National Clothing, is a chain of women's apparel stores operating throughout the country.

  • Analyzing Information Systems Using Excel Pivot Table Option

    On Table Pivot command: Click Data. Note: If the instruction in the assignment calls for you to create a Pivot Table, select Pivot Table. If a chart is required, select Pivot Chart. Select the data ranges.

  • MGMT 650 Q3 Pivot Table Excel

    651818 MGMT 650 Q3 Pivot Table Excel 11) Using the data on the Pivot Table Data Sheet, create a Pivot table showing: 1) The Movie Type, Count of Type, and Sum of Domestic Gross (in millions); columns B and D from the Pivot Table Data Sheet Have three

View More Related Solutions