Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

#Read in Files library ( readr ) #Adjust the file name and file path below for each of the 2 files. Use the same file

#Read in Files
library(readr)
#Adjust the file name and file path below for each of the 2 files. Use the same file read code from Milestone Two
firefighter <- read_csv("~/SNHU/DAT-500/Milestones/dat500_milestone_two_data_firefighter.csv")
View(firefighter)
police <- read_csv("~/SNHU/DAT-500/Milestones/dat500_milestone_two_data_police.csv")
View(police)
#Adjust the sample field names and variable names below to be the same fields used in Milestone Two
polTotSalMin<-min(police$`Total Salary`)
polTotSalMax<-max(police$`Total Salary`)
polTotSalAvg<-mean(police$`Total Salary`)
ffTotSalMin<-min(firefighter$`Total Salary`)
ffTotSalMax<-max(firefighter$`Total Salary`)
ffTotSalAvg<-mean(firefighter$`Total Salary`)
polRetMin<-min(police$Retirement)
polRetlMax<-max(police$Retirement)
polRetAvg<-mean(police$Retirement)
ffRetMin<-min(firefighter$Retirement)
ffRetMax<-max(firefighter$Retirement)
ffRetAvg<-mean(firefighter$Retirement)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions