Need instant help with Maths

profilekamran21700
InterimAssignment.xlsx
Home>Mathematics homework help>Need instant help with Maths

INSTRUCTIONS

QMB3200
APPLICATION OF QUANTITATIVE METHODS IN BUSINESS NAME OF STUDENT COMPLETING THIS ASSIGNMENT
INTERIM ASSIGNMENT Oriana Nunes
Prof. Gladys E. Simpson
Version: FALL 2017 THIS IS AN INDIVIDUAL ASSIGNMENT
DATA Student# #6100252
Definitions Gender female
ClassLevel sophmore
Age 20
GPA 3.5
HasStudentLoan no
LoanBalance NA
This excel file contains several worksheets that have specific questions (10 total).
You can add additional worksheets if you need to include supplemental material.
to support your answers
View Instructions / video demo
The video has the narrative for a very similar exercise completed in prior semesters
Spring 2016 Q&A Session - Loan Questions
mailto:[email protected] https://docs.google.com/open?id=0B1tkFhBx7weoSkxqbGhieEtQSm8 http://connect.fiu.edu/p5b25znynps/

DATA

The data below is fictitious and has been created using formulas to generate different Class Levels Gender
values for each column of data for each file. 1 Freshman 1 Female
You Need to Copy and Paste the VALUES below BEFORE analyzing the data 2 Sophmore 2 Male
to create your own version of the dataset. 3 Junior
(All students will have different versions of this data) 4 Senior
DATA
Student# Gender ClassLevel Age GPA HasLoans LoanBalance (Thoursands US$)
1 Male Senior 22 2.50 Yes 28.21 QUESTION 1: Identify the Type of Variables and Levels of Measurement
2 Female Sophmore 21 2.07 Yes 4.23
3 Female Junior 21 2.25 Yes 12.60 Variable Type Level of Measurement
4 Male Freshman 26 1.46 No 0.00 Gender Qualitative Nominal
5 Female Senior 21 2.25 Yes 16.39 ClassLevel Qualitative Ordinal
6 Female Junior 23 3.02 Yes 12.01 Age Quantitative Interval
7 Female Senior 24 3.22 Yes 20.25 GPA Quantitative Interval
8 Male Senior 24 3.47 Yes 24.55 HasLoans Qualitative Nominal
9 Male Freshman 24 1.08 Yes 5.19 LoanBalance Quantitative Ratio
10 Female Freshman 22 2.41 No 0.00
11 Male Freshman 24 2.15 No 0.00 Question 2a. Create a Pie Chart to illustrate the distribution of the variable "ClassLevel"
12 Male Sophmore 25 1.42 Yes 10.51 Make sure your graph has appropriate title and labels.
13 Female Sophmore 24 3.47 Yes 10.33 Font size should be readable. Display % and Category Name (Class level) on each Slice.
14 Female Freshman 23 3.40 Yes 5.31
15 Female Sophmore 20 2.29 Yes 8.09 Class Level # of Students
16 Male Freshman 24 3.42 No 0.00 Freshman 19
17 Male Freshman 21 3.32 Yes 6.90 Sophmore 14
18 Male Sophmore 25 3.44 Yes 8.67 Junior 12
19 Female Senior 20 3.35 Yes 20.27 Senior 15
20 Female Senior 21 2.02 No 0.00
21 Female Junior 25 3.32 No 0.00
22 Male Freshman 24 3.05 Yes 4.91
23 Female Senior 20 3.50 Yes 8.16
24 Male Freshman 22 2.18 Yes 6.39
25 Male Freshman 26 1.12 Yes 7.25
26 Female Sophmore 22 2.36 Yes 6.09
27 Male Freshman 22 2.33 Yes 4.69
28 Female Junior 25 2.37 No 0.00
29 Female Senior 23 2.41 Yes 8.52
30 Male Sophmore 22 2.26 Yes 14.06
31 Male Junior 22 2.28 Yes 12.55
32 Female Freshman 24 3.28 Yes 5.90
33 Female Sophmore 22 3.18 Yes 10.78
34 Male Junior 24 3.45 No 0.00
35 Female Senior 24 2.42 Yes 16.20
36 Male Junior 24 3.23 No 0.00
37 Female Senior 25 3.27 Yes 16.95
38 Female Freshman 20 3.32 No 0.00
39 Female Junior 24 3.22 Yes 6.83
40 Female Junior 23 2.12 Yes 12.13
41 Female Senior 22 3.23 Yes 16.44
42 Male Freshman 21 3.38 No 0.00
43 Male Senior 26 1.42 Yes 16.36
44 Male Freshman 24 1.08 No 0.00
45 Female Sophmore 22 3.38 Yes 4.12
46 Male Sophmore 26 2.09 Yes 10.88
47 Male Sophmore 24 3.36 Yes 12.54
48 Male Freshman 25 3.15 Yes 4.57
49 Male Sophmore 24 3.12 No 0.00
50 Male Sophmore 21 3.19 Yes 14.28
51 Female Junior 21 2.12 Yes 15.00
52 Male Sophmore 23 2.32 Yes 8.53
53 Male Senior 24 3.32 Yes 16.28
54 Female Senior 21 2.28 Yes 8.44
55 Male Freshman 21 1.37 No 0.00
56 Male Junior 23 2.46 No 0.00
57 Male Senior 25 1.19 Yes 28.13
58 Male Freshman 23 3.13 Yes 7.63
59 Male Junior 21 3.30 No 0.00
60 Female Freshman 20 2.03 Yes 4.40

# of Students

Freshman Sophmore Junior Senior 19.0 14.0 12.0 15.0

FREQUENCY-PROB

QUESTION 3: Create a frequency table for the variables gender and class level QUESTION 5: Create a probability table for the distribution of gender and class level
Class Level Female Male Total Class Level Female Male total
Freshman Freshman
Sophmore Sophmore
Junior Junior
Senior Senior
Total total 1.00
QUESTION 4: Illustrate the distribution of Gender and Class level by creating a graph QUESTION 6: Answer the following questions based on your results.
that includes both variables in a single Bar graph or Column graph
Do NOT include bars for the total row/column on the graph. A If a male student is randomly selected from the sample, what is the probability that it is a freshman ?
Answer A
B If we select a JUNIOR from the sample, what is the probability that is a FEMALE ?
Answer B
C If a student selected from the sample, what is the probability that the selected student is a male sophmore ?
Answer C
D What is the percentage of SENIORS in the sample ?
Answer D

AGE

Assuming this data represents a random sample of all US college students,
Use an appropriate statistical inference procedure from the ones we've studied so answer the questions below.
QUESTION 7 Based on this sample, is there evidence that male students are older on the average than female students ?
Use significance level alpha=1%. Is the conclusion the same using significance level alpha = 10% ? Comment on your results
AGE
Gender n Mean Std deviation
Female
Male
Total
Test Statistic T
P-VALUE
Conclusion For 1% significance
Conclusion For 10% significance
Comments

LOANS

Assuming this data represents a random sample of all US college students,
Use an appropriate statistical inference procedure from the ones we've studied so answer the questions below.
QUESTION 8 Based on this sample, is the there evidence of a diference between the proportion of female and male students who have loans ?
Use significance level alpha=5%. Is the conclusion the same using significance level alpha = 10% ? Comment on your results
Include a copy of all work, including pivot tables and/ or templates used. Templates can be included as an image or the actual worksheets.
X n proportion
Gender #withLoans
Female
Male
Total
Test Statistic
P-VALUE
Conclusion For 5% significance
Conclusion For 10% significance
Comments

LOANBALANCE

Assuming this data represents a random sample of all US college students,
Use an appropriate statistical inference procedure from the ones we've studied so answer the questions below based on this sample.
QUESTION 9a Provide a point estimate and a 95% confidence interval for the average loan balance of US college students with loans.
Assume that the population standard deviation for the loan balance of students with loans is known to be $1,850.
Include a copy of all work, including pivot tables and/ or templates used. HINT: CONSIDER ONLY STUDENTS WITH LOANS.
Point Estimate for the average loan balance
Margin of Error for 95% confidence interval
95% Confidence Interval for the average loan balance to
QUESTION 9b If we wanted to estimate the 95% confidence interval above with a margin of error of 300 dollars
How many students should we have in our sample ?
Number of students