Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

' Watch the video on Blackboard in Lecture 8: Excel Notes tab => Chapter 2 folder => Excel: Quantitative Variables folder titled Excel Entering Data.

image text in transcribed
image text in transcribed
' Watch the video on Blackboard in "Lecture 8: Excel Notes" tab => "Chapter 2" folder => "Excel: Quantitative Variables" folder titled "Excel Entering Data". Enter the data into Excel and Answer the following questions: A sample of 24 largest corporations revenues (in billions) in a year are given below: 52 61 59 97 49 60 55 112 91 44 48 108 113 112 118 47 43 51 87 146 76 81 43 124 Question :1) Is the variable "Revenue (in billions)" a quantitative or categorical variable? [solution] Question b) What is the largest corporation revenue? what is the smallest corporation revenue? [solution] Question c) Construct a frequency distribution (table) of revenue (billions) using classes/ groups of widths of 25 units (2549, 50-74, 75-99, etc...) [paste Excel solution below] Question (1) Construct a frequency histogram of revenue (billions) using classes/groups of widths of 25 units (25-49, 5074, 75-99, etc...) [paste Excel solution below] Question e) Discuss the shape of the frequency histogram in terms of modality, skewness, and symmetry. Would you consider this distribution to be Bell shaped (Normal)? Explain. [solution]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Graphical, Numerical, Algebraic

Authors: Ross L. Finney, Franklin D. Demana, Bert K. Waits, Daniel Kennedy

3rd Edition

0132014084, 978-0132014083

Students also viewed these Mathematics questions