Answer Happy

1 of 1 Individual Assignment 1 (Worth 10% of final grade) Submission information: All Questions must be solved using Excel. Please include the screenshots of the excel formulas and calculation in the final submission or include a neatly created d excel file with all the formulus and answers Question 1 (20 marks) Open your MYUCW portal Go to the IMF Data sets folder (located under week 0). Choose 2 countries GDP file and download its data sets. Copy the data Gross Domestic Product, Nominal, Domestic Currency from years 2010 till the end of year 2019. • Past the data in another excel worksheet. (Years in one column and GDP of each country in two other columns • Answer the following questions by using excel and provide an explanation (the explanation must be describing the outcomes observed after calculating or plotting the data sets) 1. What is the sample size of each country? 2. What is the mean, mode, median of each country 3. What is the standard deviation of each country? 4. Plot the pic chart 5. Plot the scattered diagram (GDP vs Time) 6. Plot the bar chart 7. Plot the Pareto chart 8. Pot a Histogram Question 2 (10 marks) Find out if the lines passing through the following points are parallel or not? Line A passes through (-4,7) and (0, 3) Line B passes through (3.5) and (2.1) Question 3 (20%) Find out the solution to x andy in each of the following scenarios: 1. 27-8y = 11 and 9x+3y = 5 2. Use Goal Seck function and solve the following: y = 5x-2x + 3x - 6