1. Compute descriptive statistics for liberal art colleges and research universities in the Excel file colleges and universities. Compare the two types of colleges . what can you conclude.?

2.The Excel file MBA Student survey provides data on a sample of students social and study habits. Use pivotTables to find the average age , number of nights out per week, and study hours per week by gender, whether the student is international or not, and undergraduate concentration.

We do not have access to your data.

The Excel file MBA Student survey provides data on a sample of students social and study habits. Use pivotTables to find the average age , number of nights out per week, and study hours per week by gender, whether the student is international or not, and undergraduate concentration.

1. To compute the descriptive statistics for liberal art colleges and research universities in the Excel file "colleges and universities" and compare the two types of colleges, follow these steps:

Step 1: Open the Excel file "colleges and universities" that contains the data.
Step 2: Identify the columns that provide information on the college type (liberal art or research university) and the variables for which you want to compute the descriptive statistics (e.g., enrollment, tuition, etc.).
Step 3: Select the data in the column for college type and the variables of interest. You can do this by clicking and dragging your cursor over the cells containing the data.
Step 4: Go to the "Data" tab in Excel and click on "Data Analysis" in the "Analysis" group. If you don't see the "Data Analysis" option, you may need to enable it by going to "File > Options > Add-ins" and checking the "Analysis ToolPak" box.
Step 5: In the "Data Analysis" dialog box, select the appropriate descriptive statistics option (e.g., "Descriptive Statistics") and click "OK".
Step 6: In the "Descriptive Statistics" dialog box, select the range of cells that contain the data for the variables of interest and make sure to check the box for "Summary statistics".
Step 7: Choose an output range where you want the descriptive statistics to be displayed. You can either select a range of cells or specify a new worksheet or workbook.
Step 8: Click "OK" to generate the descriptive statistics.

After performing these steps, you will have the descriptive statistics for liberal art colleges and research universities. You can compare the two types of colleges based on the summary statistics provided, such as mean, median, standard deviation, etc. Analyze the descriptive statistics to identify any differences or patterns between the two types of colleges.

2. To use PivotTables to find the average age, number of nights out per week, and study hours per week by gender, whether the student is international or not, and undergraduate concentration in the Excel file "MBA Student survey," follow these steps:

Step 1: Open the Excel file "MBA Student survey" that contains the data.
Step 2: Select the range of cells that contain the data, including the headers. You can do this by clicking and dragging your cursor over the cells.
Step 3: Go to the "Insert" tab in Excel and click on "PivotTable" in the "Tables" group.
Step 4: In the "Create PivotTable" dialog box, make sure the correct data range is selected and choose where you want to place the PivotTable (e.g., a new worksheet or an existing one).
Step 5: Click "OK" to insert the PivotTable.
Step 6: In the PivotTable Field List, drag the variables "gender," "international," and "undergraduate concentration" from the list of available fields to the "Row Labels" area.
Step 7: Drag the variables "age," "nights out per week," and "study hours per week" to the "Values" area. By default, Excel will summarize the data using the "Sum" function.
Step 8: Click on the drop-down arrow next to each variable in the "Values" area, then choose "Value Field Settings." In the dialog box, select "Average" as the summarization function, and click "OK."
Step 9: Analyze the PivotTable to find the average age, number of nights out per week, and study hours per week by gender, whether the student is international or not, and undergraduate concentration.

After performing these steps, you will have a PivotTable that displays the average age, number of nights out per week, and study hours per week categorized by the gender, international status, and undergraduate concentration. You can further analyze the results to identify any patterns or differences among these groups.

To compute descriptive statistics for liberal art colleges and research universities, follow these steps:

Step 1: Open the Excel file "colleges and universities" that contains the relevant data.

Step 2: Identify the column that denotes the type of college (liberal arts or research university) and the columns that contain the numerical variables you want to analyze (e.g., enrollment, SAT scores, percent receiving financial aid, etc.).

Step 3: Select the data range that includes the type of college and the numerical variables. You can do this by clicking and dragging over the cells or by clicking on the column letters/numbers and holding the Shift key while selecting.

Step 4: Go to the "Data" tab in Excel's toolbar and click on "Data Analysis" (if this option doesn't appear, you may need to add it through Excel's Add-Ins). From the list of analysis tools, choose the appropriate descriptive statistics option, such as "Descriptive Statistics" or "Summary Statistics." Click "OK" to continue.

Step 5: In the dialog box that appears, select the input range containing the data. Make sure to check the box "Labels in first row" if your data has headers. Choose an output range where you want the summary statistics to be displayed. You can either select an existing range or create a new one.

Step 6: Click "OK" to generate the descriptive statistics report. The output will include various statistics, such as mean, median, standard deviation, minimum, maximum, and more, for each variable separately for liberal arts colleges and research universities.

Step 7: Compare the descriptive statistics for the different types of colleges to draw conclusions. Look for any noticeable differences or similarities in terms of the analyzed variables. Consider factors like enrollment, SAT scores, financial aid, etc., to help draw meaningful conclusions.

Regarding the second question about using PivotTables to find the average age, nights out per week, and study hours per week by different categories, follow these steps:

Step 1: Open the Excel file "MBA Student survey" that contains the relevant data.

Step 2: Highlight the entire dataset, including the column headers and all the rows with data.

Step 3: Go to the "Insert" tab in Excel's toolbar and click on "PivotTable." Select "PivotTable" or "PivotTable and PivotChart" from the dropdown.

Step 4: In the "Create PivotTable" dialog box, ensure that the range is correctly selected and choose where you want to place the PivotTable (either a new worksheet or an existing one).

Step 5: Click "OK" to create the PivotTable. You will see a blank PivotTable and a "PivotTable Field List" pane on the right side.

Step 6: Drag the gender column to the "Rows" section of the PivotTable Field List.

Step 7: Drag the international or not column to the "Columns" section of the PivotTable Field List.

Step 8: Drag the undergraduate concentration column to the "Columns" section as well, beneath the "International or not" column.

Step 9: Drag the age column to the "Values" section of the PivotTable Field List. This will automatically give you the average age for each combination of gender, international or not, and undergraduate concentration.

Step 10: Repeat Step 9 for the number of nights out per week and study hours per week columns, placing them in the "Values" section as well.

Step 11: Format and analyze the resulting PivotTable to draw conclusions. Review the averages in each category and look for any noticeable differences or patterns. You can apply additional formatting, filter data, and create visualizations to further explore the results.

By following these steps, you will be able to compute the descriptive statistics for liberal art colleges and research universities as well as use PivotTables to find average age, nights out per week, and study hours per week based on different categories.