Food and Nutrition Dataset Assignment

Use the dataset Food Nutrition and answer the following questions:

1. Set the working directory for your work
2. Import the dataset in the console in the .xls(x) format
3. View the top 10 rows of the data
4. View the last 20 rows of the data
5. Show the summary of the data
6. Create a vector test using the top 10 values of variableProtein_(mg)
7. Select the top 5 rows of initial 5 variables in a matrix format
8. What is the class of theSodium_(mg)variable
9. Create a new variable EPW by dividingEnerg_Kcalwith theWater; what is the dimension of the new dataset?
10. Create a subset of the dataset, where theEnerg_Kcalis less than 500, what is the dimension of this new dataset?
11. Plot a Bar Plot betweenEnrg_KcalandWaterusing the new subset created
12. Plot a histogram ofSugar_totvariable using the new subset
13. Find the top 10 products based on following
    1. Higher theEnergy_Kcal, higher the ranking
    2. Lower thewatercontent, higher the ranking
14. Create a subset of the data whereproduct_desccontains CHEESE and list down the summary statistics of the subset
15. Using thecutfunction onwatervariable divide the whole data into 6 bins, list down the summary statistics of all the 6 bins

The objective of the project is to use the dataset 'Factor-Hair-Revised.csv' to build an optimum regression model to predict satisfaction. You are expected to

• Perform exploratory data analysis on the dataset. Showcase some charts, graphs. Check for outliers and missing values(8 marks)
• Is there evidence of multicollinearity ? Showcase your analysis(6 marks)
• Perform simple linear regression for the dependent variable with every independent variable(6 marks)
• Perform PCA/Factor analysis by extracting 4 factors. Interpret the output and name the Factors(20 marks)
• Perform Multiple linear regression with customer satisfaction as dependent variables and the four factors as independent variables. Comment on the Model output and validity. Your remarks should make it meaningful for everybody (20 marks)

Please note the following:

• You have to submit 2 files :
  1. Business Report:In this you need to submit all the answers to all the questions in a sequential manner. Your answer should include detailed explanations & inferences to all the questions. Your report shouldnotbe filled with codes. You will be evaluated based on the business report.It should include the detailed explanation of approach used, insights, inferences, all outputs of codes like graphs, tables etc.
  2. R code file: This is a must and will be used for reference while evaluating
• You must give the sources of data presented. Do not refer to blogs; Wikipedia etc.
• Any assignment found copied/ plagiarized with other group(s) will not be graded and marked as zero.

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.

Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank