MBAF 502: QUANTITATIVE REASONING & ANALYSIS

MBAF 502: QUANTITATIVE REASONING & ANALYSIS         

Submission information: All Questions must be solved using Excel.

Please include the screenshots of the Excel formulas and calculations in the final submission or include a neatly created Excel file with all the formulas and answers.

Assignment 1

Part A

• Go to the IMF Data Sets folder.
• Choose 2 countries’ GDP files and download their data sets.
• Copy the data on Gross Domestic Product, Nominal, and Domestic Currency from the years 2010 till the end of the 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 using Excel and explain (the explanation must describe the outcomes observed after calculating or plotting the data sets).

1. 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 pie chart
   5. Plot the scattered diagram (GDP vs Time)
   6. Plot the bar chart
   7. Plot the Pareto chart
   8. Plot a Histogram

Part B

Using the dataset discussed in our histogram lesson, your task is to provide a precise statistical summary and construct a histogram graph. The summary should encompass key metrics such as mean, median, mode, range, standard deviation, and quartiles, with clear explanations of each parameter's significance in understanding the dataset's central tendency, spread, and distribution.

The histogram graph should visually represent the frequency distribution of the dataset, with intervals or bins along the x-axis and the frequency or count of observations depicted by the height of the bars along the y-axis. Ensure clarity and precision in your explanations to foster a thorough understanding of the data's characteristics and distribution.

Assignment 2

2.1  A market researcher surveys 150 out of 1,200 individuals in a community, finding that 90 prefer online shopping to in-store shopping. The researcher wants to estimate the proportion of online shoppers in the community with a 90% confidence level.

1. Calculate the sample proportion and apply the finite population correction factor to the standard error calculation.
2. Determine the 90% confidence interval for the proportion of online shoppers.
3. Evaluate how the confidence interval would change if the sample were doubled, considering the finite population correction.

2.2  To assess the impact of a regional economic development program, an analyst compares median household incomes in two areas: Area X with a median income of

$75,000 (standard deviation $10,000, n=100) and Area Y with a median income of

$80,000 (standard deviation $15,000, n=100). Calculate and compare the 99% confidence intervals for median incomes in both areas.

1. Compute the 99% confidence intervals for median household incomes in both areas.
2. Discuss the implications of overlapping confidence intervals on the economic impact of the development program.
3. Analyze how differences in standard deviations between the two areas affect the confidence interval widths.