To whom it may concern, I need help with business analyst homework, I have a zip

Question

To whom it may concern,

I need help with business analyst homework, I have a zip file and need to answer questions based on it. I can send the zip to you directly via email or any other way, please help so I can get clarification on this assignment. Thank you

Please download and save a local copy of the Restaurant.zip data set. This data set has information about 130 restaurants, their characteristics, cuisines they offer and other descriptive information in five different files. The data set also has information about 138 customers, their demographics, preferences and descriptive information in three user centered files. The last file lists customer ratings of these restaurants based on food, service and overall quality. Your task is to analyze this data set to create a baseline for comparison with other data mining techniques in the coming weeks. At this time, before we have studied any new data mining approaches, you will analyze the data using your existing data analysis skills (spreadsheets, databases etc.) Some of the tools you might find useful are basic ones like averages, distributions, filtering of the data (possibly by multiple criteria). You could also consider lookup functions and pivot tables. Another solution approach might be to import the files to a relational database. The deliverable for this assignment is a list of five to ten well documented claims that can be supported by the data. These statements should be clearly identified by the underlying data, rather than being broad observations. You could start with your intuitions and test to see if your intuition is actually supported by the data. Some acceptable forms of claims are - "68% of single. male, social drinker customers prefer restaurants with smoking sections while 54% of the customers with kids prefer non-smoking restaurants." On average, restaurants with valet parking are rated higher (1.76 vs 1.43) by customers with high budgets as compared to the customers with low budgets." You should explain based on what summary statistics you are able to make this claim. Summary file descriptions: (Please refer to the README file for more detailed attribute and data type descriptions.) 1 chefmozaccepts.csv 1314 entries listing payments types accepted by the restaurants. 2 chefmozcuisine.csv 916 entries listing the 59 different cuisines served by the restaurants 3 chefmozhours4.csv 2339 entries listing the working days/hours of the restaurants. 4 chefmozparking.csv 702 entries listing the type of parking available for the restaurants. 5 geoplaces2.csv 130 entries listing all descriptive attributes of the restaurants across 21 data types. 6 rating finalcsv

Explanation / Answer

Ex:

kind of data analysis done in R by me.

Kindly send details:

i can help you out.with R software I can do it.

userprofile <- read_excel("C:/Users/nadabalavenk/Downloads/userprofile.xls")
> View(userprofile)
> summary(userprofile)
userID latitude longitude   
Length:138 Min. :18.81 Min. :-101.05  
Class :character 1st Qu.:22.13 1st Qu.:-100.98  
Mode :character Median :22.15 Median :-100.94  
Mean :21.81 Mean :-100.29  
3rd Qu.:22.19 3rd Qu.: -99.18  
Max. :23.77 Max. : -99.07  
smoker drink_level dress_preference  
Length:138 Length:138 Length:138   
Class :character Class :character Class :character  
Mode :character Mode :character Mode :character  



ambience transport marital_status   
Length:138 Length:138 Length:138   
Class :character Class :character Class :character  
Mode :character Mode :character Mode :character  



hijos birth_year interest   
Length:138 Min. :1930 Length:138   
Class :character 1st Qu.:1987 Class :character  
Mode :character Median :1989 Mode :character  
Mean :1985
3rd Qu.:1991
Max. :1994
personality religion activity   
Length:138 Length:138 Length:138   
Class :character Class :character Class :character  
Mode :character Mode :character Mode :character  



color weight budget
Length:138 Min. : 40.00 Length:138   
Class :character 1st Qu.: 53.00 Class :character  
Mode :character Median : 65.00 Mode :character  
Mean : 64.87
3rd Qu.: 74.75
Max. :120.00
height
Min. :1.200  
1st Qu.:1.600  
Median :1.690  
Mean :1.668  
3rd Qu.:1.750  
Max. :2.000  

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.