R studio ( statistics )

profileibrahim-aljabri
05022018_GIS470Survey.xlsx
Home>Mathematics homework help>Statistics homework help>R studio ( statistics )

CodedData

Student_ID Q1_Software Q1a_Excel Q1b_Word Q1c_SPSS Q1d_RStudio Q1e_NotCoor191 Q2_ExcelSkill Q3_SPSSskill Q4_Rskill Q5_MyAppsUse Q7_MyHeight Q8_Siblings Q9_BMonth Q10_BYear Q11_Eyewear Q12_Handedness Q13_Dogs Q14_Cats Q15_OtherPets Q16_LiveInUSA Q17_MealPerDay Q18_Energy Q19_FastFood Q20_SpicyFood Q21_Water Q22_DObudget Q23_OutsideUS Q24_Countrvisi Q25_OtherState Q26_GrandCanyn Q27_Exercise Q28_Smoke Q29_Sleep Q30_Bedtime Q31_TechTime Q32_Studying Q33_SleepTech Q34_WatchFavSport Q35_ASUFootball Q36_WOZsupport Q37_WOZenforcement Q38_bike2campus Q39_credithrs Q40_intlstudents Q41_Major Q42_Projects Q43_ClassGrade Q44_HotTemp Q45_ColdTemp Q46_ChangeMajo Q47_StatInterest Q48_DHHeight Q49_Concussion Q50_Sport Q51_Sleep Q52_Political Q53_Diduvote Q53a_DiduvoteNOY Q54_Movie
S01 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 1 5.92 3 9 1996 1 6 0 0 0 21 2 1 7 4 0 20 1 7 16 1 5 0 1 6 2 5 30 14 0 0 6 -99 13 2000 -99 3 4.00 -98.0 -98.0 1 5 74 0 14 9 1 1 0 What We Do in the Shadows
S02 Microsoft Excel, Microsoft Word, SPSS, R Studio 1 1 1 1 0 2 1 1 0 5.33 2 6 1997 1 6 0 0 1 20 2 0 7 3 1 50 1 2 15 1 6 0 6.5 5 0 40 10 17 0 0 6 0 22 14000 -99 3 4.00 4.4 26.7 0 4 76 0 17 6 1 1 0 500 Days of Summer
S03 Microsoft Excel 1 0 0 0 0 3 1 1 0 6.25 1 1 1997 0 6 0 1 0 20 2 0 7 5 0 30 1 3 6 1 6 0 7 5 2 8 0 13 0 0 6 0 13 2000 -99 2 4.00 -1.1 35.0 1 3 78 1 13 7 -97 1 0 Hellboy
S04 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 1 0 5.83 1 6 1996 0 6 1 0 0 21 2 1 7 4 0 100 0 0 5 0 2 0 4.5 6 0.5 7 20 16 0 1 7 0 15 15000 6 2 3.00 4.4 43.3 1 3 74 1 16 8 1 1 0 The Lord of the Rings (series)
S05 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 1 0 6.42 2 3 1997 1 6 0 0 0 5 3 0 7 2 0 20 1 15 20 1 5 0 8 5 3 5 15 9 1 1 6 0 16 6000 7 4 3.00 4.4 32.2 1 3 70 1 9 7 1 0 7 Star Wars V
S06 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 1 5.67 2 3 1999 1 6 0 0 1 7 3 0 6 3 0 10 1 3 15 1 2 0 7 4 4 27 15 -98 0 1 7 0 18 12000 6 4 4.00 15.6 37.8 1 3 75 0 -98 8 -97 0 7 3 Idiots
S07 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 1 5.50 4 5 1991 1 6 1 1 1 26 2 1 6 3 0 50 0 1 2 0 3 0 7 2 5 15 10 -98 0 -97 -97 0 12 30000 7 4 3.00 -34.4 48.9 1 4 72 1 -98 10 3 1 0 Downfall
S08 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 1 0 5.73 3 4 1995 1 6 1 0 0 22 2 0 7 4 0 150 1 3 37 1 4 0 6 7 4 8 30 12 0 0 6 0 16 15000 6 4 4.00 -98.0 -98.0 1 4 75 0 12 10 3 1 0 Probably something from Disney. Don't ask me to pick please.
S09 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 1 6.00 3 12 1995 1 6 1 0 0 22 1 0 7 4 0 70 1 3 2 1 3 0 6 7 12 10 0 2 0 1 8 0 12 1500 -99 1 3.00 15.6 35.0 1 4 77 0 2 9 1 0 6 Spirited Away
S10 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 1 -98 3 11 1992 0 6 1 0 0 4 2 0 -99 1 25 125 1 7 4 0 5 1 6 5 4 15 20 14 0 1 7 0 18 15000 -99 4 3.00 15.6 43.3 0 4 78 0 14 -98 1 0 6 the legend
S11 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 1 1 5.67 2 10 1995 0 6 0 0 0 22 3 0 6 2 24 25 1 3 27 1 5 0 8 3 3 15 20 10 2 1 8 0 17 5000 7 3 4.00 7.2 35.0 1 4 75 1 10 8 2 1 0 2001 A Space Odyssey
S12 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 -97 5.08 0 2 1998 0 7 1 0 0 19 -98 0 7 2 0 10 0 1 2 0 6 0 7 5 1 10 20 8 2 1 7 1 16 10000 7 3 3.67 10.0 37.8 1 3 -98 0 8 8 1 0 6 Pitch Perfect
S13 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 1 1 5.58 0 11 1996 1 7 0 0 0 3 3 0 7 3 10 100 0 8 7 1 1 0 7 4 1 125 30 14 0 1 7 0 18 1000 6 4 4.00 10.0 32.2 0 5 79 0 14 7 3 -97 -97 lion king
S14 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 1 0 5.92 1 5 1996 1 6 0 1 1 21 2 0 7 5 0 30 1 5 8 1 6 0 8 4 0 8 0 10 0 1 8 0 15 10000 6 3 4.00 -6.7 37.8 0 5 78 0 10 -98 1 1 0 Apocalypse Now Redux
S15 Microsoft Excel, Microsoft Word, R Studio 1 1 0 1 0 2 1 2 1 5.75 0 1 1997 1 7 1 0 0 2 -98 0 -99 2 5 70 1 4 10 1 5 0 8 7 1.5 8 25 3 0 1 7 0 15 4000 -99 5 4.00 15.6 37.8 1 5 72 -97 3 8 -97 0 7 Running maze
S16 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 1 1 5.25 3 8 1996 0 6 -98 0 0 21 3 0 6 5 0 10 1 1 10 0 4 0 7 4 1 20 10 11 0 1 7 1 16 15000 7 3 3.00 10.0 32.2 1 5 76 -97 11 7 1 0 6 The Grand Budapest Hotel
S17 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 1 5.92 3 10 1996 0 6 1 0 0 21 2 0 7 3 0 20 1 1 5 1 6 0 8 2.5 1 10 15 14 3 0 7 1 16 15000 6 4 4.00 4.4 43.3 1 3 77 0 14 8 2 1 0 The Guardian
S18 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 2 2 1 5.00 4 3 1994 0 6 0 0 0 3 2 0 7 5 25 100 0 2 4 1 4 1 6 4.5 3 3 5 14 1 0 8 0 21 2000 -99 4 4.33 15.6 37.8 1 5 72 0 14 7 -97 0 7 catch me if you can
S19 Microsoft Excel, Microsoft Word, SPSS, R Studio 1 1 1 1 0 2 1 1 0 5.17 4 12 1996 1 6 0 1 0 21 3 0 7 2 0 0 0 1 5 1 3 0 8 4 3 25 15 7 1 1 7 0 18 5000 7 3 3.00 15.6 32.2 1 3 74 0 7 8 -97 0 6 Star Wars: Return of the Jedi
S20 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 -98 0 6.17 3 8 1996 1 7 1 0 0 21 4 1 7 3 4 60 0 1 5 0 6 0 6 6.5 5 8 15 6 1 1 6 1 15 15000 6 4 4.00 4.4 43.3 0 4 76 1 6 8 2 1 0 step brothers
S21 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 2 2 -97 5.33 2 6 1995 1 6 1 0 1 16 2 0 -98 4 0 20 1 3 9 1 3 0 8 4.5 0 10 30 17 0 1 8 0 16 30000 6 4 3.00 4.4 32.2 0 3 77 1 17 9 1 1 0 I have a lot of favorite movies
S22 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 0 5.25 2 5 1997 0 6 1 1 0 20 2 0 7 4 0 0 1 12 6 0 2 0 7 5 4 2 30 17 0 1 7 0 17 1200 -99 4 3.00 15.6 32.2 0 4 72 0 17 8 1 1 0 mulan
S23 Microsoft Word 0 1 0 0 0 3 1 1 1 6.25 1 4 1997 1 6 0 0 0 2 -98 0 6 3 5 5 1 2 3 1 2 0 10 4 5 15 30 3 0 1 7 0 18 5000 6 2 4.00 10.0 30.0 1 4 -98 -97 3 8 3 0 7 None
S24 Microsoft Excel, Microsoft Word 1 1 0 0 0 2 1 1 1 4.83 1 9 1996 1 7 1 0 0 21 2 0 7 4 0 8 1 1 3 0 2 0 7 5.5 3 42 30 1 0 1 7 0 18 8000 6 3 4.00 13.9 32.2 1 4 71 0 1 9 -97 1 0 The Harry Potter Series
S25 Microsoft Word 0 1 0 0 0 2 1 1 1 5.33 1 7 1996 0 6 0 1 0 2 -98 1 7 5 15 130 1 3 2 0 5 1 9 6 3 10 20 14 0 -97 -97 0 18 3000 6 4 4.00 18.3 26.7 1 4 69 -97 14 9 2 0 6 Flipped
S26 Microsoft Excel, Microsoft Word 1 1 0 0 0 4 1 1 0 5.38 0 3 1996 1 6 0 0 0 1.5 2 0 -98 3 24 50 1 2 4 0 3 0 10 5 2 30 15 0 1 8 -98 17 10000 6 5 4.00 15.6 35.0 0 4 74 0 15 9 2 0 7 Farewell My Concubine
S27 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 2 1 -97 5.92 2 10 1986 1 6 0 0 0 31 3 0 6 3 0 75 1 12 42 1 6 1 6.5 5 3 6 25 6 0 0 6 1 18 15000 -99 3 4.00 -6.7 43.3 0 4 74 1 6 8 4 1 0 The Hunt for Red October
S28 Microsoft Excel, Microsoft Word 1 1 0 0 0 3 1 1 1 5.92 1 11 1997 1 6 1 1 0 20 2.3 0 -99 5 0 25 1 13 13 1 5 0 5.5 7 8 20 30 5 0 0 8 -99 15 25000 6 4 3.00 8.9 37.8 0 5 73 -97 5 7 1 1 0 V for Vendetta
S29 I am NOT taking the survey from Coor 191 0 0 0 0 1 2 1 1 1 5.67 1 9 1998 0 6 0 0 0 19 2 0 7 4 15 50 0 1 8 1 5 0 6 5.5 25 20 20 3 0 1 7 0 15 4000 6 2 3.00 15.6 37.8 1 1 -97 1 3 7 1 0 6 This is the End
S30 Microsoft Excel, R Studio 1 0 0 1 0 3 1 1 0 5.83 2 11 1996 0 7 0 0 1 21 4 0 7 4 5 40 1 3 10 1 5 0 7 5 20 7 30 4 0 0 6 0 15 25 -99 4 2.67 -1.1 37.8 0 4 67 0 4 6 1 1 0 Clockwork Orange
S31 Microsoft Excel, Microsoft Word, I am NOT taking the survey from Coor 191 1 1 0 0 1 3 1 1 -98 5.83 0 4 1995 1 6 1 1 1 22 4 0 6 2 5 40 1 6 12 0 5 0 6 3 1 20 0 -98 1 1 7 1 11 6000 -99 4 4.00 4.4 43.3 0 4 73 0 3 8 2 0 6 Drive

Sheet10

MetaData

Q1 Q2 Q3 Q4 Q5 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22 Q23 Q24 Q25 Q26 Q27 Q28 Q29 Q30 Q31 Q32 Q33 Q34 Q35 Q36 Q37 Q38 Q39 Q40 Q41 Q42 Q43 Q44 Q45 Q46 Q47 Q48 Q49 Q50 Q51 Q52 Q53 Q54
Long Name Which of the following software programs can you find on the computer you are working on? What is your level proficiency with Microsoft Excel? What is your level of proficiency with SPSS? What is your level of proficiency with R and/or R Studio? Have you accessed any software programs through the "MyApps" section of your MyASU home page? What is your height in feet and inches? How many brothers and sisters do you have? In what month were you born? In what year were you born? (Please use four digits, for example, "1998" instead of "98") Do you wear corrective eyewear, such as glasses or contact lenses? Are you left-handed or right-handed? Do you have any pet dogs? Do you have any pet cats? Do you have any pets other than cats or dogs? For how many years have you lived in the United States? on average, how many meals do you eat each day? do you consume one or more energy drink in an avevrage week ? Taco Bell or Chipotle? When you eat spicy food, how spicy do you like it to be? How many bottles of water do you purchase in an average week? How much money do you spend on an average week eating at restaurants or fast food establishments, outside of any student meal plan you may have? (Please use US dollars) Have you traveled outside of North America? How many different countries have you visited in your life? How many of the United States have you visited in your life? Have you been to the Grand Canyon? How many times do perform rigorous activity a week? Do you smoke cigarettes or cigars On an average night how many hours do you sleep What is your typical bedtime? On an average day, how many hours do you spend watching television and/or playing video or computer games? Average time spent studying a week Within 30 minutes of going to sleep, for how many minutes do you interact with a cell phone, tablet, or e-reader? What kind of athletic events do you prefer to watch? How many home Sun Devil football games did you attend this past season? Do you support the existence of "Walk Only Zones" on ASU's Tempe campus? What is your perception of the level of enforcement of "Walk Only Zones" on ASU's Tempe campus? Do you commute to campus via bicycle at least once each week? How many credit hours are you taking thies semester? How many international students do you think are enrolled at ASU this year? What is your primary academic major? How enjoyable do you consider group projects? What letter grade do you predict that you will receive in this class? What temperature (degrees F) do you consider "too cold" for outdoor activities in Tempe? What temperature (degrees F) do you consider "too hot" for outdoor activities in Tempe? Have you changed your major in your time at ASU? How would you describe your interest level in statistics? In feet and inches, what do you estimate to be professor Hondula's height? Have you ever had a concussion? What is your favorite sport to play? How many hours of sleep you you believe are optimal for undergraduate students? With which American political party do your preferences tend to align? Did you vote in the November 2016 presidential election? What is your favorite movie?
ShortName [10 characters, no spaces, no special characters] Software ExcelSkill SPSSskill Rskill MyAppsUse MyHeight Siblings BMonth BYear Eyewear Handedness Dogs Cats OtherPets LiveInUSA MealPerDay Energy FastFood SpicyFood Water DObudget OutsideUS Countrvisi OtherState GrandCanyn Exercise Smoke Sleep Bedtime TechTime Studying SleepTech Favourite Sport Event Popular sports WOZ_support WOZ_enforcement bike2campus credit_hrs intl_students Major Projects ClassGrade HotTemp ColdTemp ChangeMajo Stat_Inter DH_Height Concussion Sport Sleep Political Didyouvote Movie
GroupObservations check marks Multiple Choice Multiple Choice multiple choice Multiple Choice Quantitative answer, subjective to each person. Has numerical value and cannot be a negative number Quantitative answer, subjective to each person Quantitative answer, subjective to each person- 12 possible answers Quantitative answer, subjective to each person Yes or no question Two categories of answers: left handed or right handed Yes or no answer Yes or no answer Yes or no answer Will be a number Will be a number Yes or no Categorical answer Subjective to each person Multiple choice answer, wide range, subjective for each person Quantative answer, subjective for each person Open to a very wide range of data. Limited amount of information gathered. Categorical Response Quantitative Quantitative Qualitative 7 categories Yes, no, or other (fill in the blank) numerical descriptive, discrete Numerical Fill in the blank with a numerical value Categories numerical value yes/no free short answer yes/no numberical value Quantitative It's a fill in answer, not multiple choice. Mulitple choice, has questions to determine range of enjoyment Question with answer between A-F Fil-in answer Fill-in answer Only yes, no, or not sure answers Multiple choice, with ranges of enjoyment Fill in the blank Multiple Choice- Yes, No, Maybe Fill in the Blank Fill in the blank Multiple Choice Multiple choice Fill in the blank
VariableType [Numeric or String] numeric numeric numeric numeric numeric Numeric Numeric Numeric Numeric String String String string string numeric numeric string String Numeric Numeric Numeric String Numeric Numeric String Numeric String Numeric String Numeric Numeric Numeric String Numeric String String String Numeric Numeric String String String Numeric Numeric String String Numeric String String Numeric String String String
MeasurementLevel [Nominal, Ordinal, Ratio] ratio/scale ordinal ordinal ordinal nominal ratio ratio Ordinal Ordinal Nominal Nominal nominal nominal nominal ratio ratio nominal Nominal Ordinal Ratio Ratio Nominal Ratio Ratio Nominal Ratio Ordinal Ratio Ordinal Ratio Ratio Ratio Nominal Ratio Nominal Nominal ratio Nominal Ordinal Ordinal/Ratio Ratio Ratio Nominal Ordinal Ratio Nominal Nominal Ratio Nominal Nominal Nominal
Validity [High, Medium, Low] high low low low low high High High High High High high high high high medium medium High High Low Low High Low Low High High High High High High High High High High High High High High High Medium Medium Medium Medium Medium High Medium High Medium Medium High High High Medium
Accuracy [High, Medium, Low] high medium medium medium medium Medium High High High High Medium high high high high medium medium High High Medium Medium High High High High Medium High Medium Medium Medium Medium Medium Medium High Medium Medium Medium High Medium Medium Medium High High High n/a n/a Med High High Medium NA NA High
Precision [units, digits] n/a digit (scale) digit (scale) digit (scale) yes/no feet and inches # of siblings Month name Year Yes or No Left or Right yes/no yes/no yes/no First decimal place nearest whole number yes/no N/A Digits Digits US Dollar N/A Digits Digits N/A Digits N/A Digits Digits Digits Digits Digits N/A number of games yes/no N/A yes/no credit number digits n/a n/a Units Units Units n/a n/a Digits Units NA Digits Units Yes/No NA
Data entry notes Q1a_Excel Q1b_Word Q1c_SPSS Q1d_RStudio Q1e_NotCoor191 "I am NOT taking the survey from Coor 191" one answer was 5.8 with no unit of measuremet attached, changed to -98 Total siblings (summed if both brothers and sisters) January - December year Student 18 gave a range of 20-30 which was averaged to 25 if answer has a range (eg 5-7) average of range is put in. Recoded worded responses to numerical value. Half hours and averages included. Half hours represented by .5 Had to reformat some data, less than 1 = .5 recoded worded responses to numerical value Took number assignment from orginial datasheet 1 person put in hours, recorded as -98 because not sure if this was a yes or not to biking, 2 answered "long board" recorded as -99 other Spectrum had only 2 recurrent answers converted to number grades by below schematic Temperatures were converted and rounded to the nearest decimal in Celsius. Temperatures were converted and rounded to the nearest decimal in Celsius. DATA Entry Notes: Answers were coded converting responses to total inches Possible Response Codes: 67-79 & -98. Answers have several categories. Most are answered in feet and inches. other answers have inches but not feet. There are also string answers which do not contain a numeric response such as "no clue" or simply left blank. Two answers were grouped together, "running" and "long-distance running" as the same answer. There is no way to know which football is meant. The two answers "none" are labeled -98. The answeres are coded 1 through 17 alphabetically. Omitted vauge answers such as "8-10" and "6-8". Rounded up 7.5 to 8
Recoding scheme 0 - No (Unchecked) 1 - Yes (Checked) 1 - I have never used it 2 - Beginner 3 - Intermediate 4 - Expert 1 - I have never used it 2 - Beginner 3 - Intermediate 4 - Expert 1 - I have never used it 2 - Beginner 3 - Intermediate 4 - Expert (-) 98 - No Answer 0 - No 1 - Yes (-) 98 No Answer (-) 97 Not Sure continuous continuous 1 - January 12 - December continuous 0 - No 1 - Yes 6 - Right 7 - Left 0 - No 1 - Yes (-) 98 - No Answer 0 - No 1 - Yes 0 - No 1 - Yes Continuous Continuous 0 - No 1 - Yes 6 - Taco Bell 7 - Chipotle (-) 99 - Other (-) 98 - No Answer 1 - I avoid spicy food 2 - Mild 3 - Medium 4 - Hot 5 - Mouth on Fire Continuous Continuous 0 - No 1 - Yes Continuous Continuous 0 - No 1 - Yes 1 - Less than once a month 2 - About once a month 3 - A couple of times each month 4 - Once a week 5 - A few times each week 6 - Daily 0 - No 1 - Yes Continuous 1 - 8pm 2 - 9pm 3 - 10pm 4 - 11pm 5 - 12pm 6 - 1am 7 - 2am 8 - 3am Continuous Continuous Continuous 1- Badminton 2- Baseball 3- Basketball 4- Bowling 5- Fencing 6- Football 7- Golf 8- Gymnastics 9- Hockey 10- Running 11- Rock Climbing 12- Rowing or Crew 13- Rugby 14- Soccer 15- Swimming 16- Tennis 17- Volleyball (-98) - NA/None 0- 0 games 1- 1-2 games 2- 3-6 games 3- All 7 games 0 - No 1 - Yes (-) 97 - Not Sure 6 - To Strict 7 - Just Right 8 - Not Strict Enough (-) 97 - Not Sure 0 - No 1 - Yes (-) 98 - Not Interpretable (-) 99 - Other continuous continuous 6 - Urban Planning 7 - Geography (-) 99 - Other 1 - Very unenjoyable 2 - Somewhat unenjoyable 3 - Neither enjoyable nor unenjoyable 4 - Somewhat enjoyable 5 - Very enjoyable A+ = 4.33 A = 4.00 A- = 3.67 B+ = 3.33 B = 3.00 B- = 2.67 C+ = 2.33 C = 2.00 D = 1.00 E/F = 0.00 0 - No 1 - Yes 5 - Very interested 4 - Somewhat interested 3 - Neither interested nor disinterested 2 - Somewhat disinterested 1 - Very disinterested Continuous 0 - No 1 - Yes (-) 97 - Maybe 1- Badminton 2- Baseball 3- Basketball 4- Bowling 5- Fencing 6- Football 7- Golf 8- Gymnastics 9- Hockey 10- Running 11- Rock Climbing 12- Rowing or Crew 13- Rugby 14- Soccer 15- Swimming 16- Tennis 17- Volleyball (-98) - NA/None Answers represented on a 1-10 in hours 1- Democrat 2- Republican 3- Independant 4- Libertarian (-) 97 - Unsure Q53 0 - No 1 - Yes Q53a_DiduvoteNOY 0 - Voted 6 - Was eligible 7 - Was not eligible Nominal
(-) 99 Other (-) 98 No Answer/ Unable to Interpret (-) 97 Not Sure