QMB 2100 Intro to Statistics Microsoft Excel Project Profess

QMB 2100 Intro to Statistics Microsoft Excel Project Profess.
QMB 2100 Intro to Statistics Microsoft Excel Project Professor: Rene Choy Miami Dade College North Campus School of Business The following project is recommended to be completed using Microsoft Excel with Megastat and Word and you should work on it during the time you spend on the Statistics Lab class QMB 2100L.Remember the lab is managed by the Business Resource Center staff in Room 2201-Section 1.The project is separated into Modules or Steps which you should be able to complete as the semester goes by.None of the modules can be done by hand, the point here is to learn how to use Excel/Megastat on your own, for now and the future.This project is EXTRA CREDIT, but required, and is to be tuned in to Professor Choy by the deadline date for Lab hours.All work MUST be typed and presented in the same order as below. Let s try to learn using statistical analysis and your curiosity. Module 1: Data Collection: Find something you want to study. a.Create a survey to collect the information. b.Find a target population and collect it.Alternatively there may already be information online or otherwise and you just collect the information from those sources if you think it is already available. c.You should collect more than 30 sample data of whatever information you are collecting and more than 3 different sets of data.Example 3 sets of data: age, sex and job description, the give it to 30 people or more for collection of the survey. d.Explain something interesting you learned about this module. Module 2: Data Presentation: Present the information. a.Create a table in Excel with the data collected b.Create at least 1 frequency distribution table c.Create a histogram or any other graph you think will present the information best. d.Explain something interesting about the data, some relationship, etc. Module 3: Data Analysis: Using the formulas in Excel and the data collected, calculate the following for all data sets: a.Mean b.Median c.Mode d.Highest number e.Lowest number f.Variance and standard deviation. g.Skewness Coefficient h.Describe something interesting about the data. Module 4: Relationship Analysis: Using the tools in Excel.Select 2 sets of data twice.Example: say you collected: (1) sex, (2) age, (3) income, (4) height; then select say (1)(2) as well as (2)(3) then think of them as relationships (A) and (B).For this to work best it is recommended you select numerical information only, a.k.a Interval or Ratio level data. a.Create 2 scatter plot diagrams with the two relationships (A) and (B), one scatter plot diagram for each. b.Calculate the correlation coefficient.Explain the relationship. c.Calculate the slope of the regression line and the Y intercept. d.Write down the regression line e.Explain what you learned about the relationship between the 2 values selected.
QMB 2100 Intro to Statistics Microsoft Excel Project Profess

Don't use plagiarized sources. Get Your Custom Essay on
QMB 2100 Intro to Statistics Microsoft Excel Project Profess
Just from $13/Page
Order Essay
Homework On Time
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.


Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.


Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.


Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.


Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers