Instructions

1. Use appropriate data visualization and descriptive statistical tools to analyze and summarize the survey data in the excel file questionnaire-database.
2. Compute and interpret confidence intervals for your ratio variables and key proportions for your categorical variables.
3. Summarize and explain the results in a well-written Word document and provide a well-organized Excel workbook with the full results. “Well-organized” means clear and descriptive worksheet tabs in logical order. You should comprehensively describe what statistical analysis you did and include embedded charts and portions of your Excel worksheets, as well as your interpretation of results and conclusions.
4. The report should be self-sufficient so that the reader would not need to search through the Excel workbook to understand what you did, so the excel workbook is only as a backup to verify your work. Use the Snipping tool in Excel to capture portions of the worksheets and paste them into the Word document.
Questionnaire on The Basic Living Conditions of Chinese Students

The object of this questionnaire is the Chinese students studying in UC. More and more Chinese students come to study in the United States. The relatives and friends of these students are usually very interested in their life in the United States, and many their Chinese peers also want to seek more information, especially financial information, supports for their own future study abroad, so the data collected in this questionnaire mainly aim to provide these Chinese relevant people some reference on the basic living expenses and the living conditions of the students studying in UC.

1. What best describes your affiliation to the UC ? (categorical data)
A. Carl H. Lindner College of Business (LCB)
B. College-Conservatory of Music (CCM)
C. College of Design, Architecture, Art and Planning (DAAP)
D. College of Engineering and Applied Science (CEAS)
E. McMicken College of Arts and Sciences (A&S)

2. What’s your current stage of learning? (categorical data)
A. Undergraduate,
B. Master’s degree
C. Doctor’s degree

3. How much scholarship do you get per semester from your college ? (ratio data)
A. $0
B. _____________ (Please offer an approximate integer figure)

4. What’s your rental housing type? (categorical data)
A. Apartment
B. Studio
C. House
D. Dormitory provided by UC

5. What’s your average cost of rent per month (including water, heating and electricity)? (ratio data)

______________ (Please offer an approximate integer figure)

6. Do you cook or buy your meals mainly? (categorical data )
A. Cook by yourself.
B. Buy
C. Half and half
D. The meal plan in school

7. How much do you need to cover the board expenses each month? (ratio data)

______________ (Please offer an approximate integer figure)

8. Do you have part-time job (including RA,TA or any job that can bring an income to you) ? (categorical data )
A. No, I don’t have any part-time job.
B. Yes, I have a part-time job.
C. Yes, I have more than one part-time jobs.

9. How much is your average total living cost each month ? (ratio data)

______________ (Please offer an approximate integer figure)