How many customers of the Smile Clinic do eat rice? How many customers are Male and Female? What are the Mean and Median of the ages in the data? What are the Mean and Median of participants who eat rice?

Data Handling and Business Intelegence

You are an intern at Nutritionist centre ‘Smile clinic’, who has been tasked to analyse customers data to see whether they eat rice in their daily meal for healthy diet point of view. The clinic has a copy of Microsoft Excel and has just downloaded a free copy of the open-source SPSS data mining software. The company has used Microsoft Excel before but not SPSS.

You need to produce a report to evaluate the following: How many customers of the Smile Clinic do eat rice? How many customers are Male and Female? What are the Mean and Median of the ages in the data? What are the Mean and Median of participants who eat rice?

Show your findings on Pie, Bar or Histogram.

The dataset is provided in xls and csv format: smile_clinic.xls, smile_clinic.csv

Using the smile_clinic.csv provided in conjunction with SPSS give a specific example of clustering. Show your workings with screenshots and explain you results.