Project Description:
The dataset in file Restaurant tips dataset.xlsx contains tips data for different customers. Use excel to predict restaurant tips.
Tools Used: MS Excel
Dataset: Link
The following are the features in the dataset:
| sex | Gender of the customer |
| smoker | Indicates if the customer is a smoker or not |
| day | Day of the restaurant visit |
| time | Indicates whether the tip was for lunch or dinner |
| size | Number of members dining |
| total bill | Bill amount in USD |
| tip | Tip amount in USD |
Project Solution:
Cleaning Data:
- Check for missing value
Find the features that are independent and dependent:
-
- First need to convert text values into numeric values
Then apply Covariance and Correlation to check the dependence.
The results are as follows:
Identify which predictive problem is needed.
Applying Regression to build a Predictive Model
Calculate the predicted and actual tips values. Calculate the RMSE(Root Mean Square Error) of the model.
–END–