QBA 241 Quantitative Business Analysis Assignment

Assignment Help Basic Statistics

Reference no: EM132546527 , Length: 2 pages

QBA 241 Quantitative Business Analysis - Canadian University of Dubai

The project is individual. You are required to complete this lab project based on the self-generated data in the Excel file. You have to discuss and appraise the given project. You must submit soft copy of Excel file with your lab project on the Moodie (MyCUD) no later than 23:59, 18th of June 2020. Provide Student' Name, ID Number, Course Name/Code, Faculty Name.

The project submitted after the deadline will be graded out of 5 points.

Lab Project - Coronavirus Disease (COVID-19)

Problem 1. Open New Workbook (File> New Workbook) in Excel and create a new column with the title "Confirmed Cases". According to your country of birth (write the country of birth in the Excel file), select the country on the World Health Organization (WHO) website and record all confirmed cases from l' of April, 2020 to of May, 2020.

Problem 2. Calculate mean, median, mode, and standard deviation to describe the data of confirmed cases using Data>Data Analysis>Descriptive Statistics. Make precise interpretations of each statistical measure in Text Box (Insert>Text Box).

Problem 3. Determine class width and create a frequency table with 6 classes. The table should have

Problem 4. Draw bar chart describing the obtained relative frequency. Provide description.

Problem 5. Calculate first, second and third quartiles (Q1, Q2, Q3, Excel: =QUARTILEO) and interquartile range (IQR.Q3-Q1). Make precise interpretations of each statistical measure.

Attachment:- Quantitative Business Analysis.rar

Reference no: EM132546527

Questions Cloud

Calculate the value of share : The required rate of return on equity is 10%. Please calculate the value of Share

Compute the amount of paid-in capital : The LeeGon Company is authorized to issue 600,000 shares of 10 par value common stock. Compute the amount of organization expense to be charged against income

Similarities between a bond and an annuity : What should be the value of the bond if the market rate is 15% quarterly? Discuss similarities between a bond and an annuity.

Find and calculate the cost per unit and the margin for fb : Discuss whether traditional costing method is beneficial or activity base costing methods explain. Calculate the cost per unit and the margin for FB

QBA 241 Quantitative Business Analysis Assignment : QBA 241 Quantitative Business Analysis Assignment Help and Solution, Canadian University of Dubai - Assessment Writing Service

Purple in gram-stains bacteria smear : Explain why some cells are pink and others are purple in Gram-stains bacteria smear.

Calculate the gain-loss on disposal of shares : Advice and justify Mr. Ahmed to whether retain or sell his debentures. Give proper financial reasoning.

Prepare operating income statements for silgan containers : What will be the relationship between total operating income for the four-year period as reported under absorption and variable costing? Explain

Invest in an insurance company : What is the level of risk when invest in an insurance company at the moment?

User Account

All Pages