Question
1. Create a dataframe called Missing_Values_Info that contains information on the number of missing values for each field in the M&M dataset. Include the names
1. Create a dataframe called Missing_Values_Info that contains information on the number of missing values for each field in the M&M dataset. Include the names of the fields too.
2. Create a cleaned dataset as follows: Remove the observations where type or color info is missing If the diameter or mass values are missing then recode the missing value as the mean of other observations within the same type and color
3. Create a dataframe MnM_summary that contains the information on the mean diameter and mass for each type and color of M&Ms.
below is the data please help me in R language
type color diametermass peanut butter blue 16.2 2.18 peanut butter brown 16.5 2.01 peanut butter orange 15.48 1.78 peanut butter brown 16.32 1.98 peanut butter yellow 15.59 peanut butter brown 17.43 2.59 peanut butter yellow 15.45 1.9 peanut butter green 17.3 2.55 peanut butter yellow 16.37 2.07 peanut butter blue 16.67 2.26 peanut butter 15.58 1.66 peanut butter brown 1.84 peanut butter red 15.24 1.58 peanut butter yellow 16.2 2.06 peanut butter brown 14.73 1.37 peanut butter yellow 15.55 1.76 peanut butter brown 15.31 1.57 peanut butter orange 15.27 2.01 peanut butter blue 16.29 2.21 peanut butter orange 16.02 1.79 peanut butter green 15.22 1.6 peanut butter blue 2.02 peanut butter brown 15.62 1.7 peanut butter green 16.87 2.47 peanut butter yellow 15.74 1.64 peanut butter blue 15.79 peanut butter blue 15.91 1.78 peanut butter yellow 15.74 1.73 peanut butter orange 15.83 1.75 peanut butter green 15.99 1.84 peanut butter brown 15.2 1.73 peanut butter blue 15.36 1.61 peanut butter red 14.76 1.52 peanut butter green 15.48 1.78 peanut butter yellow 15.32 1.62 peanut butter green 17.31 2.53 yellow 15.5 1.71 peanut butter green 15.13 1.55 peanut butter yellow 1.7 peanut butter brown 15.31 1.65 peanut butter green 16.45 2.08 peanut butter yellow 15.31 1.61 peanut butter yellow 15.86 1.93 peanut butter blue 16.65 2.26 peanut butter yellow 16.04 1.87 peanut butter blue 16.22 1.97 peanut butter green 16 1.97 peanut butter brown 13.98 2.32 peanut butter yellow 15.66 1.58 peanut butter green 15.13 1.36 peanut butter orange 15.14 1.4 peanut butter 16.24 2.05 peanut butter green 16.76 2.1 peanut butter brown 15.6 1.7 peanut butter blue 16.03 1.93 peanut butter blue 15.43 1.55 peanut butter yellow 16.19 1.97 peanut butter orange 15.14 1.48 peanut butter green 16.21 1.94 peanut butter orange 15.4 1.6 peanut butter brown 15.9 1.9 peanut butter blue 16.46 2.2 peanut butter orange 15.46 1.62 peanut butter brown 16.04 1.95 peanut butter red 16.45 1.92 peanut butter yellow 15.23 1.48 peanut butter yellow 14.77 1.48 peanut butter brown 15.86 1.84 peanut butter blue 15.2 1.49 peanut butter green 16.83 2.32 peanut butter orange 16.91 peanut butter orange 16.09 1.91 peanut butter red 15.75 1.84 peanut butter brown 15.84 1.87 peanut butter yellow 15.02 1.39 peanut butter red 16.23 1.69 peanut butter green 15.72 1.81 peanut butter yellow 16.43 2.16 peanut butter yellow 15.29 1.69 peanut butter red 15.65 1.78 peanut butter blue 1.62 peanut butter yellow 15.01 1.56 peanut butter red 15.05 1.53 peanut butter green 16.65 2.18 peanut butter red 17.5 2.53 peanut butter yellow 16.08 1.75 peanut butter yellow 15.22 1.68 peanut butter 15.87 1.79 peanut butter yellow 16.19 1.87 peanut butter brown 16.36 2.04 peanut butter blue 15.62 1.74 peanut butter yellow 15.48 1.69 peanut butter yellow 16.06 1.81 peanut butter blue 15.88 1.73 peanut butter red 15.67 1.53 peanut butter orange 15.66 1.69 peanut butter green 15.1 1.77 peanut butter yellow 15.4 1.65 peanut butter brown 15.63 1.79 peanut butter yellow 15.44 peanut butter blue 16.19 2.09 peanut butter brown 15.2 1.48 peanut butter brown 16.94 2.46 peanut butter orange 15.99 1.91 peanut butter brown 15.85 1.82 peanut butter yellow 16 1.88 peanut butter brown 15.12 1.62 peanut butter green 16.3 1.93 peanut butter yellow 15.67 1.76 peanut butter red 15.29 1.47 peanut butter orange 16.07 1.91 peanut butter blue 16.42 2.04 peanut butter 14.89 1.4 peanut butter blue 15.41 peanut butter green 15.24 1.72 peanut butter red 15.89 1.82 peanut butter green 16.78 2.1 peanut butter yellow 16.48 2.25 peanut butter blue 17.43 2.54 peanut butter yellow 16.85 2.21 peanut butter brown 15.32 1.73 peanut butter blue 1.7 peanut butter orange 15.78 1.93 peanut butter 15.61 1.82 peanut butter brown 15.85 1.7 peanut butter blue 15.39 1.65 peanut butter orange 15.87 1.68 peanut butter brown 16.42 2.06 peanut butter orange 15.69 1.81 peanut butter yellow 16.45 2.01 peanut butter yellow 15.48 1.57 peanut butter green 15.53 1.72 peanut butter blue 15.77 1.71 peanut butter yellow 16.28 1.95 peanut butter red 15.1 1.49 peanut butter brown 15.89 1.79 peanut butter yellow 14.84 1.5 peanut butter blue 15.35 1.55 peanut butter orange 16.19 1.96 peanut butter brown 15.77 1.67 peanut butter yellow 15.39 1.46 peanut butter yellow 16.1 1.98 peanut butter brown 16.29 2 peanut butter green 17.61 2.63 15.89 1.79 peanut butter blue 16.11 1.79 peanut butter brown 15.73 1.62 peanut butter yellow peanut butter orange 15.26 1.45 peanut butter brown 16.22 1.93 peanut butter red 17.33 2.41 peanut butter yellow 15.47 1.54 peanut butter yellow 16.04 1.92 peanut butter red 15.44 1.39 peanut butter red 15.89 1.68 peanut butter brown 14.65 1.31 peanut butter yellow 15.53 1.58
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started