1. Frequency distribution of Nominal DataMethods of Describing Sets of Data (see a similar example of this question in the word file (Freq dist of Nominal Data ) and the companion excel file (Graph of Table 4 in the example of freq dist nominal data ) on Moodle Week 2 (Examples of materials similar to the questions in Project Assignment 1)In a sample survey of 40 students selected randomly from VIU, the following information were collected from each student about the content of origin (Asia, Africa, North America, South America, Antarctica, Europe and Australia) and gender (male , Female) Use the data given in Table 1 to construct three tables showing the distribution by content (Table 2), by Gender (Table 3), and by both content and gender (Table 4). Use Excel to construct a column graph of the data in Table 4. Copy the graph from Excel to this word solution file. See the solution belowIDContentGender1AsiaMale2AsiaMale3AsiaFemale4EuropeMale5AfricaFemale6AfricaMale7South AmericaMale8AsiaFemale9AsiaMale10South AmericaFemale11AfricaMale12South AmericaMale13AsiaFemale14AsiaMale15South AmericaFemale16AsiaMale17AsiaMale18AsiaFemale19EuropeMale20AfricaFemale21AsiaMale22AsiaMale23AsiaFemale24EuropeMale25AfricaFemale26AfricaMale27South AmericaMale28AsiaFemale29AsiaMale30South AmericaFemale31AfricaMale32South AmericaMale33AsiaFemale34AsiaMale35South AmericaFemale36AsiaMale37AsiaMale38AsiaFemale39EuropeMale40AfricaFemaleSolution Fill in each of the followingTable 2: Distribution by ContentContentFrequencyPercent (%)AfricaAsiaEuropeSouth AmericaTotalTable 3 Distribution GenderCountryFrequencyPercent (%)Male Female TotalTable 4 Distribution by content and genderContentGenderMaleFemaleAfricaAsiaEuropeSouth Americab. To get a column graph of the information in Table 4, follow the following instructions.1. Copy The whole table 4 above (all its 5 row and 5 columns) , open an excel file and paste Table 4in that Excel file. ( See the companion excel file called Table 4)2. After pasting Table 4 in the excel sheet , highlight all Table 4 and click on INSERT in the menu of the Excel fileand click twice on the column choice. You will see the graph on your excel sheet3. click twice (right mouse) on the graph in the excel sheet and you will see a side menu ,select copy from that side menu.4. go to your solution word file , select the place where you will paste the graph and paste the graph. Save your solution word file Insert the Column Graph of Table 4 below Q2. Descriptive Statistics of Quantitative Data (measured on Ratio scale)In a sample survey of 40 students selected randomly from VIU, the following information were collected from each student about their age and the cumulative Grade Point Average ( GPA).Use the data given in the table below and the Data Analysis Option on Excel 2010 or later to obtainthe 18 descriptive statistics (Mean, Standard Error, Median, Mode, ….. MAD, IQR ) of both variables Age and GPA . Table Data on Age and GPA collected from a sample of 40 students selected randomly from VIU.IDAgeGPA12332253.23243.24243.15253.56302.87322.98332.9935410403.911312.51225313243.214223.515502.816242.817262.718253.319233.420263.52129322233.223243.224253.125253.526262.827272.928282.92928430273.931252.53223333223.234253.535272.836282.837242.738243.339253.440263.5Note: Copy the data for the two variables into an excel fileand follow the instructions given in the word file (Descriptive Statistics using Excel) on Week 2 of Moodle and the example (Descriptive Statistics using Excel example) in the same place. After you find the required statistics in excel copy them and paste your answer below.Answer: Q3. Frequency distribution and Histogram of Quantitative dataUse the data on age for the 40 students in the table presented above and the given bins, namely this dataAgeBins23252530243524402545305032333540312524225024262523262923242525262728282725232225272824242526 To construct a frequency distribution table of age and the histogram of the age. And present both below.Note: Copy these data and the bins into an excel file and follow the instructions given in the word file (How to Create a Histogram in Excel) on Week 2 of Moodle and the example (create histogram example on excel) in the same place. Make sure you read the instructions carefully . After you find the required frequency table and the histogram in the excel file , copy them and paste your answer below.ANSWERTHE FREUENCY TABE THE HISTOGRAM Q4. Correlation between two Quantitative data sets Use the data for age and GPA of the sample of 40 students given in question 7 above, to calculate the correlation coefficient between the age data and the GPA data.Copy the two columns of data into an excel file and use the datadata analysis option to find the required coefficient. Read the word file (Correlation using excel) to help you understand how to use that option on Excel. After you calculate the correlation in excel, copy you answer belowAnswer:The Correlation between age and GPA: Q5. Multiple Linear Regression Equation.See the Excel file (multiple regression example on Week 2 Moodle to do similar analysis for this question.Use the following data for a sample of 11 males . The data represent the Systolic Blood Pressure (dependent variable y) and the two independent variables (X1 Age in years, and X2 Weight in pounds).Systolic Blood Pressure Data Y X1 X21325217314359184153671941627321115464196168742201375418814961188159652071284616716672217a. Do the multiple regression analysis using Excel datadata analysisregression to obtain the regression results and then use them to find the regression equation.b. Use the coefficients to present the regression equation and use to estimate the blood pressure of a man of age 65 and weight of 220 pounds.Copy the Answer from Excel and paste it below.Refer below attached documents for examples