Please help me with the attached document thank you 

 ATTACHMENT PREVIEW Download attachment1MATH 221 Statistics for Decision MakingWeek 2 iLabName:_______________________Statistical Concepts that you will learn after completing this iLab:Using Excel for StatisticsGraphicsShapes of DistributionsDescriptive StatisticsEmpirical RuleWeek 2 iLab Instructions-BEGINData have already been formatted and entered into an Excel worksheet.Obtain the data file for this lab from your instructor.The names of each variable from the survey are in the first row of the Worksheet.This row has a background color of gray to identify it as the variable names. All otherrows of the Minitab Worksheet represent a certain students’ answers to the surveyquestions. Therefore, the rows are called observations and the columns are calledvariables. On page 6 of this lab, you will find a code sheet that identifies thecorrespondence between the variable names and the survey questions.Follow the directions below and then paste the graphs from Excel in the grey areasfor question 1 through 3. Type your answers to questions 4 through 11 where noted inthe grey areas.When asked for explanations, please give thorough, multi-sentence orparagraph length explanations.PLEASE NOTE that various versions of Excel may have slightly different formulacommands.For example, some versions use =STDEV.S while other versions woulduse =STDEVS (without the dot before the last “S”).The completed iLab Word Document with your responses to the 11 questions will bethe ONE and only document submitted to the dropbox. When saving and submittingthe document, you are required to use the following format: Last Name_ FirstName_Week2iLab.Week 2 iLab Instructions-END

View the Answer2Creating Graphs1.Create a pie chart for the variable Car Color: Select the column with the Carvariable, including the title of Car Color.Click onInsert, and thenRecommended Charts.It should show a clustered column and clickOK.Oncethe chart is shown, right click on the chart (main area) and selectChange ChartType.SelectPieandOK.Click on the pie slices, right clickAdd Data Labels,and selectAdd Data Callouts.Add an appropriate title.Copy and paste thechart here.black; 17%blue; 17%dark blue; 3%green; 9%orange; 6%red; 14%silver; 31%white; 3%Count of Car Color2.Create a histogram for the variable Height. You need to create a frequencydistribution for the data by hand.Use 5 classes, find the class width, and thencreate the classes.Once you have the classes, count how many data points fallwithin each class. It may be helpful to sort the data based on theHeightvariablefirst.Create a new worksheet in Excel by clicking on the + along the bottom ofthe screen and type in the categories and the frequency for each category.Thenselect the frequency table, click onInsert, thenRecommended Chartsandchoose the column chart shown and clickOK.Right click on one of the bars and

Show 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"