Answered step by step
Verified Expert Solution
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.
' 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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started