University of Amsterdam Basic Functions of Excel Data Exercise Worksheet

Xnvgyla96

Programming

University of Amsterdam

### Question Description

I'm working on a r exercise and need a sample draft to help me study.

For these questions you need to know the basic functions of Excel and R. You will need to organize datasets and create pivot tables with Excel and calculate mean median mode and standard deviation using R. Then tell me any potential trouble one may run into in the process.

It's all very basic stuff. I will send you the 2 datasets with more specific instructions after the bid is settled.

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

If you have any queries, please tell me. I will solve it right away :DAll the sheets have been attached in the excel docs
To get months simply use the following command :-=TEXT(A10,”mmmm”)2.In the Pivot table we need to select the average value. I am also attaching screenshots of pivot table as well as the screenshot of R notebook. I am attaching both the excels.================== R CODE =======================library(tidyverse)list.files(path = "../input")mydata = read.csv("../input/rduavg/RDU_AVG_DAILY.csv")colMeans(mydata[sapply(mydata, is.numeric)]) median(mydata\$Avg.Daily.Temp)sd(mydata\$Avg.Daily.Temp)min(mydata\$Avg.Daily.Temp)max(mydata\$Avg.Daily.Temp)

Sheet2
Avg Daily Temp
MONTH
50 January
36 January
39 January
36 January
40 January
39 January
34 January
27 January
30 January
30 January
32 January
31 January
30 January
38 January
39 January
38 January
40 January
52 January
40 January
38 January
25 January
31 January
33 January
41 January
41 January
38 January
42 January
41 January
52 January
41 January
79 July
81 July
85 July
85 July
81 July
81 July
82 July
83 July
81 July
81 July
85 July
89 July
87 July
78 July
73 July
76 July
78 July
81 July
83 July
88 July
90 July
91 July
91 July
90 July

YEAR
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011
2011

Page 1

Sheet2
86
83
86
89
90
88
79
52
44
30
32
43
50
56
54
46
50
52
52
43
35
37
37
54
47
38
45
47
35
45
54
49
55
58
47
43
44
52
89
84
87
87
87
86
87
91
85
80
74
76
80
83
84
85
85

July
July
July
July
July
July
July
January
January
January
January
January
January
January
January
January
January
January
January
January
January
January
Janu...

funqbjfubg_k (407)
UCLA
Review
Review

Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4