what is the step to solve missing data on excel ? like this question Marilyn Mar
ID: 3753655 • Letter: W
Question
what is the step to solve missing data on excel ? like this question
Marilyn Marshall, a Professor of sports economics, has obtained a data set of home attendance for each of the 30 major league baseball franchises for each season from 2010 through 2016. Dr. Marshall suspects the data, provided in the file AttendMLB, is in need of a thorough cleansing. You should also find a reliable source of Major League Baseball attendance for each franchise between 2010 and 2016 to use to help you identify appropriate imputation values for data missing in the AttendMLB file.
Are there any missing values in Dr. Marshall’s data? If so, identify the teams and seasons for which data are missing and which values are missing for each of these teams and seasons. Use the reliable source of Major League Baseball Attendance for each franchise between 2010 and 2016 you have found to find the correct value in each instance.
Are there any values in Dr. Marshall’s data that appear to be erroneous? If so, identify the teams and seasons for which data appear to be erroneous and which values appear to be erroneous for each of these teams and seasons. Use the reliable source of Major League Baseball Attendance for each franchise between 2010 and 2016 you have found to find the correct value in each instance.
Explanation / Answer
The steps that we can follow to manage the missing data in excel are as follows:
Here the functions which you can use are as follows :
DELBLANK(R1,s) - the highlighted range with the data in range R1 (by columns) omitting any empty cells.
DELNonNum(R1,s) - the highlighted range with the data in range R1 (by columns) omitting any non-numeric cells
CountFullRows(R1, TRUE) = the number of rows in range R1 which don’t have any empty cells
CountFullRows(R1, FALSE) = the number of rows in range R1 which don’t have any non-numeric cells
Here you can substitute values which can be considered similar to the values removed.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.