Naman DA Assignment 2

.xlsx

School

Seneca College *

*We aren’t endorsed by this school

Course

BAN 120

Subject

Industrial Engineering

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by MajorSummerButterfly35

Numbers Average Median Mode 45 53.15 52 45 78 69 45 78 12 25 69 63 47 89 77 63 55 38 21 49 73 32 35 For the following Twenty numbers , Calculate the average , median and mode using both EXCEL functions

Excel Data Analysis Took Pack Column1 Mean 53.15 Standard Error 4.838592 Median 52 Mode 45 Standard Deviation 21.63884 Sample Variance 468.2395 Kurtosis -0.91194 Skewness -0.21636 Range 77 Minimum 12 Maximum 89 Sum 1063 Count 20 and Excel Data Analysis Tool Pack

Rate of Return Total Value Current Investment 19000 6% 20140 Rate of Return 6% 6.50% 7.50% 9% 9.25% Total 20140 10.00% 11% Question 2 : The rate of return on an investment has been stable around 6% since past 5 years. However it is sp year the rate can go up up to 11%. The value of Theresa's current investment is $19,000. She would like to kno the resultant value of her investment in case the rate goes up to different levels before reaching the maximum Create an excel one way data table to find out the resultant amount if the rate increase to 6.5% 7.5% 9% 9.25% 10% 11%

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help