MATH1322 Introduction to Statistical Computing

Tasks

On Canvas you will find five files, a mix of csv files and SAS formatted datafiles. This information has been modified from data sourced from Food.com (Majumder et al 2019). See the image on the last page for guidance on the relationship between the tables.

Use this information complete the following Tasks using SAS coding, with the goal of exploring the following questions.

Question: Which recipes receive higher user ratings?

To assist you in answering this research question, you will need to complete at least the tasks listed on the following page using SAS code:

1. Read the data into SAS using a data step or using a libref where appropriate. Ensure variables are formatted accordingly where required.

2. Produce a graph that shows the number of ingredients in the recipes in the data set. Ensure the graph is clearly labelled with the correct names and an informative title.

3. Using PROC SQL, determine the average rating given by each user that have reviewed more than 5 recipes. Report the number of users that meet this criteria and the overall average from these users in your report.

4. Create a new variable “Complexity” to represent recipes with a low number of steps to those with a high number of steps, where low is less than 10 and high complexity is 10 or more steps.

5. Use a t test to determine whether the Complexity (created in task 4) leads to a difference in calories per serve, but only for recipes that have more than 15 ratings. Use α=0.03.

6. Include any other relevant analysis of this data source to assist you to understand which recipes receive higher user ratings.