MIS 446 Colorado State University Global Campus R Scrit to Explore Data Worksheet

Create an R script (*.R) file to explore two variables together from one *.csv data set file using cross tabulation and to explore a single quantitative variable from another *.csv data set file using box plot according to the steps given below. Give the script file a name that includes your first name and last name like this Solution-W1-FirstName-LastName.R.

Complete these steps:

Step 1

Include these 3 lines of comments at the beginning of your R (*.R) script file to document the script:

# Name: Your name (e.g., Jane Doe)# Course: Your course (e.g., MIS446)# Module: 2 

Step 2

Read in the data set file

cafe_ratings.csv

Download cafe_ratings.csv

and organize its  data into a cross-tabulation table showing the distribution of price across cuisine. Use four price categories of (1) $50 and under, (2) $50 to $100, (3) $100 to $150, and (4) $150 to $600.

Your R code should be well commented and well organized to explain what the code does.

Step 3

Enter this Sys.time() R function to print the current date and time and this Sys.getenv(“username”) R function to print your username as shown here:

Sys.time() [1] “2022-08-09 09:35:57 EDT” > Sys.getenv(“username”) [1] “omora” >”>

Step 4

Read in the data set file top20.csv and display the university endowment data in a box plot. Are the data presented well?

Your R code should be well commented and well organized to explain what the code does.

Step 5

Enter this Sys.time() R function to print current date and time and this Sys.getenv(“username”) R function to print your username as shown here:

Sys.time() [1] “2022-08-09 09:35:57 EDT” > Sys.getenv(“username”) [1] “omora” >”>

Save and execute your *.R script file and display the results of its execution in the RStudio console and/or the Plots tabs.

Take screenshots of your ordered steps to demonstrate successful completion of your work. The screenshot should show the R commands you applied and the results you obtained. Do not capture trial and error results. Only your final results should be captured. Your screenshot(s) should look something like this:

Summarize your work on this assignment as follows:

Explain how you completed this work and how you resolved the issues you faced, if any. Explanation of your work should be relevant and detailed.

Interpret the results you obtained from your work. Interpretation of results should be relevant and accurate.

Reflect on your experience with this assignment and the lessons you learned. Reflection on experience should be relevant and personalized.

To submit your response to this assignment:

Prepare all the required *.R script file and screenshots.

Prepare your summary of your work (what you did, interpretation of results, and reflection).

Use the

Submission Template – Assignment

Download Submission Template – Assignment

document and complete all its sections from your prepared screenshots and work summary.

Make sure your completed Submission Template – Assignment document

follows the order given in the submission template.

Submission Template – Assignment
Student Identifying Information
Name:
Course:
Module:
Date:
Embed Here Your R (*.R) Script File or Submit it Separately:
Insert Here APA-Titled and Ordered Screenshots of Steps:
Add Here APA-Styled Explanation of Your Work (200 words):
Add Here APA-Styled Interpretation of Your Results (200 word):
Add Here APA-Styled Reflection on Your Experience (200 words):
input-file3551599085586042941
cuisine
price rating
French
142
28
French
137
28
French
127
28
French
303
28
French
106
28
French
127
28
French
100
28
French
114
27
French
64
27
French
107
27
French
80
27
French
114
27
Italian
54
27
Italian
87
27
Italian
79
27
Italian
52
26
Italian
47
26
Italian
76
26
Italian
97
26
Italian
78
26
Italian
87
26
Italian
73
26
Italian
54
26
Italian
98
26
Chinese
69
24
Chinese
63
24
Chinese
26
23
Chinese
34
23
Chinese
57
23
Chinese
31
23
Japanese
95
28
Japanese
84
28
Japanese
105
27
Japanese
91
27
Japanese
80
27
Japanese
83
27
Japanese
154
27
Japanese
84
26
Japanese
520
26
Japanese
55
26
Japanese
75
26
Japanese
99
26
American
112
28
American
78
27
American
60
27
American
77
27
American
46
26
American
36
23
American
13
21
American
43
21
Page 1