Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+2 How can the effectiveness of global virtual teams be improved?

Answered: 1 week ago

Question

=+1 What are the major issues related to international T&D?

Answered: 1 week ago