Your Perfect Assignment is Just a Click Away

Starting at $8.00 per Page

100% Original, Plagiarism Free, Customized to Your instructions!


GEOG101 University of Memphis Quantitative Basics in Excel Lab Questions

GEOG101 University of Memphis Quantitative Basics in Excel Lab Questions

Question Description

Lab write-up directions:

For this lab, you will be processing raw responses to the class census in order to test two research hypotheses:

  • H1: UO students who identify their ethnicity as non-white are more likely to consider food an important part of their culture.
  • H2: International students at UO are more likely to agree that trying new foods is the best part of traveling.

For the purposes of this lab, assume that the class census was distributed as an online survey to a random sample of UO students. You are aiming to generalize your results to the UO student population as a whole.

To answer your research questions, you will need to organize and categorize the data produced by Qualtrics in an Excel spreadsheet. You will need:

We strongly suggest using a word processing application to type up and save your answers before pasting them into Canvas. (This will avoid losing work if Canvas has issues.) Where open written answers are required, please use complete sentences. Approximate length of answer is specified for each question.

Data Analysis Instructions:

1. First, make a folder/working directory on your computer for Geog391 if you don’t already have one. Then save both an original copy of the Excel file (eg “GEOG391 Census Sum2018 LabM4” from Canvas) and a separate, working copyon your computer (eg., “Lab M4_Working copy”). It is easy to accidentally delete data or mix up variables in Excel, so you should get in the habit of saving an original copy that you do not edit.

2. Familiarize yourself with the data. Are the questions in order? What do rows and columns represent? How can you tell which question the responses in each column are answering? What kind of data is in each column? Which columns are ordinal, nominal, etc.?

3. Clean the data. You will only need part of the data to test your hypotheses and answer all the questions in the lab. Delete all the columns (select the entire column by clicking the letter, then “Edit” -> “Delete”) EXCEPT for: Q16_3, Q16_5, Q7, Q10, and Q29.


4. Evaluate non-response. Not all of the respondents that started the census completed it: there are some blank rows in the remaining data. Go ahead and delete those blank lines. (Note: it can be hard to see, but line 44 is missing a response to Q29). How many responses are left? Given the size of the sample (there are 88 students in the class), are there enough non-responses to threaten the validity of the data?

5. Categorize and count. In order to get from the data to a test of the hypothesis, you will have to turn the responses into counts. First, you will set up a cross-tab (See Schutt 2017, 182-185). For Hypothesis 1, we are testing the relationship between the importance of food to culture and ethnicity. Accordingly, your cross-tab will have one variable (importance of food to culture) tabulated against the other variable (ethnicity). In the data we measured “importance of food to culture” using a self-reported indication of agreement with a five-level ordinal ranking, ranging from “strongly agree” to “strongly disagree.” We measured ethnicity using a self-reported indicator, using categories drawn from the US 2010 Census. Looking at hypothesis 1, the only ethnic distinction that matters to this question is the distinction between “white” and “other”. Therefore, the crosstab should look like this:

White Other (totals)
Strongly agree
Somewhat agree
Neither agree nor disagree
Somewhat disagree
Strongly disagree

Complete for the first 15 rows of the data.

6. Test the hypothesis (H1). If there is no relationship between ethnicity and the importance of food, then the numbers of respondents of each group who picked each responses should be roughly similar. Here is a complete cross-tab for the whole class:

White Other (totals)
Strongly agree 13 23 36
Somewhat agree 14 9 23
Neither agree nor disagree 6 3 9
Somewhat disagree 2 1 3
Strongly disagree 1 1 2
(totals) 36 37 73

(Note: This was made using an Excel formula complicated enough we’re not going to try to make you do it yourselves for this Lab.)

It looks like white-identifying respondents tended to assign a lower rank to the importance of food to their culture. But is that relationship statistically significant? To see, run a chi-square test using this website (Links to an external site.).

Select the appropriate number of rows (5) and columns (2) in the first screen, and then in the second screen enter the data above. Click calculate. Is the relationship statistically significant? (Hint: look for the p-value.)

7. Repeat for Hypothesis 2. Complete the cross-tab visualizing the relationship between international student status and agreement that food is the best part of traveling. Complete this cross-tab for the first 15 rows of class census data. Note: since Q10 allowed respondents to check all that apply, each cell may have multiple responses: you’ll have to look in each one to see if it includes “international student”.

International Student Non-international (totals)
Strongly agree
Somewhat agree
Neither agree nor disagree
Somewhat disagree
Strongly disagree

Below is the cross-tab for all of the responses.

International Student Non-international (totals)
Strongly agree 7 34 41
Somewhat agree 4 17 21
Neither agree nor disagree 4 5 5
Somewhat disagree 0 0 0
Strongly disagree 1 1 1
(totals) 16 57 73

The p-value for this crosstab is about ~.22; well short of statistical significance.

8. Reclassify Data. However, our hypothesis doesn’t concern all five points along the Likert scale–it only inquires about the binary difference between agreeing or not agreeing. Add together the counts for the “Strongly” and “Somewhat Agree” rows, and the counts for “Neither agree nor disagree”, “Somewhat disagree”, and “Strongly disagree” rows to create a new 2 x 2 cross-tab (see below). Run the chi-square test again. How has the significance of the result changed?

    International Student Non-international (totals)
    More than half
    Half or less
    (totals) 16 57 73

    "Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

    Order Solution Now

    Our Service Charter

    1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

    2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

    3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

    4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

    5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

    6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.