亚洲天堂免费在线,丰满人妻在公车被猛烈进入电影,国产又黄又潮娇喘视频在线观看 ,久久黄色大片,国产女人伦码一区二区三区不卡,校花娇荡吟喘上课,亚洲区中文字幕在线不卡电影,亚洲黄色网页

合肥生活安徽新聞合肥交通合肥房產(chǎn)生活服務(wù)合肥教育合肥招聘合肥旅游文化藝術(shù)合肥美食合肥地圖合肥社保合肥醫(yī)院企業(yè)服務(wù)合肥法律

代寫ISOM 2007、代做 Python 程序設(shè)計(jì)

時(shí)間:2023-12-10  來源:合肥網(wǎng)hfw.cc  作者:hfw.cc 我要糾錯(cuò)


 

ISOM 2007 - Programming for Business Analytics

  2023/2024 (First Semester)

Assignment 2

Due date: December 8, 2023 (12:00, noon)

    Instructions:

  ➢ Read the Assignment Requirements posted in the UMMoodle before attempting to solve the following problems with Python programs.

➢ Both the hardcopy and softcopy of your assignment should be submitted on time. All programs (.ipynb files) are to be compressed and uploaded to the UMMoodle under the “Submit Assignment 2” button. The compressed file should be named with your student number such as “ba12345_Ass2.zip”.

Before the questions:

This task revolves around analyzing a dataset containing information about universities in the United States. The dataset includes various attributes, such as graduation rates, enrollment statistics, and demographic data. The goal is to explore this dataset, answer a series of questions, and provide insights and comments based on the findings.

Throughout the analysis, you will be calculating correlations, ranking universities based on specific criteria, comparing different university types, and investigating the relationship between enrollment and the representation of different ethnic groups. By working through these questions, you will gain a deeper understanding of the data and identify trends and patterns that can inform decision-making in higher education.

Once you have completed the provided questions, consider what other data might be useful to enhance your analysis. For example, you could examine the relationship between tuition fees, financial aid, and student retention rates or investigate the impact of university size and location on the student experience. Explain that with additional data, how you can perform further analysis to support your comments and insights, enabling you to make more informed recommendations to

                 P.1

 

 universities, policymakers, and prospective students.

 Question 1: Graduation rate in states (30%)

Which states have the highest/lowest average graduation rates for Bachelor's degrees within 4 years?

• Read the dataset into a Pandas DataFrame. (2%)

• Group the data by the 'State abbreviation' column. (3%)

• Calculate the mean graduation rate for each state. (3%)

• Find the top 5 states with the highest average graduation rates. (6%)

• Find the bottom 5 states with the lowest average graduation rates. (6%)

• Compare the top 5 and bottom 5 states, discuss the possible reasons that why these states have

highest (lowest) graduation rates. (10%)

Sample Output:

The states with the highest average graduation rate: State abbreviation

    Rhode Island Massachusetts Connecticut

District of Columbia Pennsylvania

56.875000 51.285714 50.588235

**.375000 46.911392

Name: Graduation rate - Bachelor degree within 4 years, dtype: float64

The states with the lowest average graduation rate: State abbreviation

Alaska

New Mexico

Montana

Hawaii

Alabama

Name: Graduation rate - Bachelor degree within 4 years, dtype: float64

Question 2: Women students in public/private universities (20%)

Compare the average percentage of undergraduate enrollment that are women for public and private universities.

• Filter the dataset into two separate DataFrames: one for public universities and one for private universities. (4%)

• Calculate the average percentage of undergraduate enrollment that are women for each DataFrame. (5%)

• Calculate the median percentage of undergraduate enrollment that are women for each DataFrame. (5%)

13.000000 16.750000 18.142857

18.250000 21.100000

    P.2

 

•

Compare the results and discuss any observed differences. (6%)

 Sample Output:

Public universities have an average of 54.88% women in undergraduate enrollment.

Private universities have an average of 59.07% women in undergraduate enrollment.

Public universities have a median of 56.00% women in undergraduate enrollment.

Private universities have a median of 58.00% women in undergraduate enrollment.

Question 3: University ranking (50%)

Students care much about university ranking. However, ranking university is not an easy task. It necessitates the consideration of numerous aspects and the assignment of appropriate significance. Predominantly, three factors are widely used: the admission rate, the graduation rate, and student selectivity. Below please analyze these factors and offer your astute observations and recommendations concerning university ranking.

• Calculate the correlation between the 'Applicants total' and 'Admissions total' columns in the dataset, also the correlation between the 'Applicants total' and Enrolled total' columns in the dataset. Interpret the correlation values and discuss any potential implications. (10%)

• Rank all the universities based on their graduation rate for Bachelor's degrees within 4 years and student selectivity using the 25th percentile SAT or ACT scores. First, add up the SAT Critical Reading, SAT Math, and SAT Writing 25th percentile scores, then normalize it by dividing 2400 (the full score of SAT). Normalize the ACT Composite 25th percentile score by 36 (the full score of ACT). In this way, both scores are in percentage and can be compared. Then, use the larger of these two values as the student selectivity criterion. Create a composite ranking by averaging the rankings for graduation rate and student selectivity. Discuss the ranking and identify the top 10 universities according to three criteria:

1, the graduation rate; (10%)

2, the student selectivity; (10%)

3, the composite criterion. (10%)

Discuss which criterion is more reliable, what are the caveats of the criteria, and what other factors (if have) may need to be included. (10%)

Sample Output (the indices may not necessarily be the same):

        P.3

 

     Bonus Question (10%)

Investigate the relationship between the total enrollment and the percentage of different ethnic groups (Asian, Black or African American, Hispanic/Latino, and White) at universities, and compare the results for private and public universities.

• Calculate the total enrollment for each ethnic group by multiplying the percentage of the total enrollment by the total enrollment for each university. Sum up the total enrollment for each ethnic group across all universities. Calculate the percentage of each ethnic group's enrollment in comparison to the overall total enrollment. Discuss the representation of each ethnic group in US universities based on the calculated percentages.

• Separately calculate the total enrollment and percentages of different ethnic groups for both private and public universities. Calculate the results.

• Select the private and public universities that rank in top 100 (ranking together) with criterion “student selectivity”, then calculate the results.

• Compare and discuss any observed differences in the representation of ethnic groups in the previous 3 results.

 請(qǐng)加QQ:99515681 或郵箱:99515681@qq.com   WX:codehelp

 

掃一掃在手機(jī)打開當(dāng)前頁
  • 上一篇:代寫DAT 560M、代做R編程語言
  • 下一篇:代做COMP2396、代寫 java編程語言
  • 無相關(guān)信息
    合肥生活資訊

    合肥圖文信息
    仿真分析咨詢外包服務(wù)-結(jié)構(gòu) / 熱 / CFD流體 / 電磁 / 光學(xué)CAE代做
    仿真分析咨詢外包服務(wù)-結(jié)構(gòu) / 熱 / CFD流體
    流體仿真外包多少錢_專業(yè)CFD分析代做_友商科技CAE仿真
    流體仿真外包多少錢_專業(yè)CFD分析代做_友商科
    CAE仿真分析代做公司 CFD流體仿真服務(wù) 管路流場(chǎng)仿真外包
    CAE仿真分析代做公司 CFD流體仿真服務(wù) 管路
    流體CFD仿真分析_代做咨詢服務(wù)_Fluent 仿真技術(shù)服務(wù)
    流體CFD仿真分析_代做咨詢服務(wù)_Fluent 仿真
    結(jié)構(gòu)仿真分析服務(wù)_CAE代做咨詢外包_剛強(qiáng)度疲勞振動(dòng)
    結(jié)構(gòu)仿真分析服務(wù)_CAE代做咨詢外包_剛強(qiáng)度疲
    流體cfd仿真分析服務(wù) 7類仿真分析代做服務(wù)40個(gè)行業(yè)
    流體cfd仿真分析服務(wù) 7類仿真分析代做服務(wù)4
    超全面的拼多多電商運(yùn)營技巧,多多開團(tuán)助手,多多出評(píng)軟件徽y1698861
    超全面的拼多多電商運(yùn)營技巧,多多開團(tuán)助手
    CAE有限元仿真分析團(tuán)隊(duì),2026仿真代做咨詢服務(wù)平臺(tái)
    CAE有限元仿真分析團(tuán)隊(duì),2026仿真代做咨詢服
  • 豆包網(wǎng)頁版入口 Trae 目錄網(wǎng) 排行網(wǎng)

    關(guān)于我們 | 打賞支持 | 廣告服務(wù) | 聯(lián)系我們 | 網(wǎng)站地圖 | 免責(zé)聲明 | 幫助中心 | 友情鏈接 |

    Copyright © 2025 hfw.cc Inc. All Rights Reserved. 合肥網(wǎng) 版權(quán)所有
    ICP備06013414號(hào)-3 公安備 42010502001045