Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Mat 144 major assignment 1

07/01/2021 Client: saad24vbs Deadline: 7 Days

Grading Sheet

Budget Expenses

Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.

Points Possible Points Earned Comments

Location identified 2

Travel Expenses identified and calculated for the entire group with an Excel formula 14

Lodging Expenses identified and calculated for the entire group with an Excel formula 14

Food Expenses identified and calculated for the entire group with an Excel formula 14

Entertainment Expenses identified and calculated for the entire group with an Excel formula 14

Total Budget 2

Question 1 total 60 0

Loans

Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.

Possible Points Points Earned Comments

Calculations for both loans are correct 21

Explain in 25 to 100 words which loan is the best option and why. 14

Question 2 total 35 0

Stats

Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.

Points Possible Points Earned Comments

Mean, Median, Mode 6

Range, Minimum, Maximum 3

Standard Deviation 4

Frequency Distribution 6

Histogram 6

z-Score 5

Question 3 total 30 0

Worksheet 1

Total for Worksheet 1 125 0

Budget Expenses

Location

Budget Total: Formula

Transportation

Item Qty Price each Total price Source

Description numbers Number or NA Formulas Link or citation

(Add rows as needed)

Lodging

Item Qty Price each Total price

Description numbers Number or NA Formulas Link or citation

(add rows as needed)

Food

Item Qty Price each Total price

Description numbers Number or NA Formulas Link or citation

(add rows as needed)

Entertainment and Misc.

Item Qty Price each Total price

Numbers numbers Number or NA Formulas Link or citation

(add rows as needed)

You are going on a dream vacation with five of your closest friends for a week. Since you are taking a math course, your friends asked you to come up with a budget to see how much it will cost each of you. Please identify your location in the US and then determine the total costs - remember to be thorough so the group does not run out of money. Your expense list must include the following (this means that you cannot book an all-expenses paid trip) • Travel expenses, such as plane or bus fare, local travel within the area. • Lodging expenses. If you plan to camp, you will include expenses for your camping gear. • Food expenses while you are on your trip. One way to do this is to research cost of living in your destination county to find out what a local family would expect to budget to pay for food. Another is to research local restaurants and groceries. • Entertainment or activity expenses and/or miscellaneous expenses that may occur.


Loans

Loans

Loan A Loan B

Principal (P) (same for both loans) number number

rate ( r) number number

# of Compoundings per year (n) number number

time in years (t) number number

Payment (PMT) formula formula

Total Paid formula formula

Interest Paid formula formula

Source Link or citation Link or citation

Suppose you all decide you want to finance the trip with a loan. Find two different available offers (the internet is a good source). Make sure the interest rate and loan length are both different in each option. Calculate the monthly payment amount, the total amount you will pay over the life of the loan and the total interest you will pay. NOTE: Do not provide personal information on the internet. You can find loan rates on major bank and credit union websites without providing personal information. Loan payment formula: PMT = P*(r/n)/(1 - (1 + r/n)^(-n*t)) PMT is the payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years. You must use Excel formulas including cell references to calculate the loan payment, total paid and interest paid. Discuss which loan would be a better option and why: (14 points!)


Stats

Data

Copy from Data ← Copy the data from the Data tab. Make sure and paste as "Values (V)" (icon with "123") so that this data does not regenerate every time you change the sheet. Frequency Distribution

Copy from Data ← Low High Bins Cumulative Frequency Frequency

Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula

Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula

Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula

Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula

Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Descriptive Statistics (remember to create the Histogram, too).

Copy from Data Mean Formula

Copy from Data Median Formula

Copy from Data Mode Formula

Copy from Data Range Formula

Copy from Data Minimum Formula

Copy from Data Maximum Formula

Copy from Data Standard Deviation Formula

Copy from Data Your height Number

Copy from Data z score for your height Formula

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Copy from Data

Using the data set of 102 random heights provided use Excel formulas to find the following: Mean Median Mode Range Minimum Maximum Standard deviation Frequency distribution Histogram The z score for your height (use the computed mean and standard deviation)


Data

Generated Data

71.3

70.6

70.6

60.1

70.0

69.4

75.2

64.9

69.4

73.7

72.0

65.1

71.4

67.2

69.6

71.9

68.3

71.4

65.5

70.4

64.4

62.7

70.3

60.0

64.9

71.3

70.7

69.6

74.0

64.1

70.1

69.9

65.5

70.5

69.6

71.7

67.4

65.1

69.0

73.4

67.3

71.1

68.4

69.6

65.2

71.7

62.4

69.6

71.0

64.9

74.1

65.7

67.0

63.1

71.5

66.5

66.8

67.4

69.1

76.2

67.5

67.1

62.8

67.3

66.6

73.5

71.0

69.0

69.6

68.1

67.5

65.4

64.7

63.1

70.2

62.9

68.0

67.8

66.6

71.6

71.3

71.6

68.4

71.5

66.9

65.5

67.4

66.7

62.6

70.3

68.1

77.9

70.8

73.2

64.9

66.4

69.8

72.6

61.5

63.7

65.7

72.0

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Helping Hand
University Coursework Help
Top Essay Tutor
Peter O.
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer
Peter O.

ONLINE

Peter O.

Hello, I can assist you in writing attractive and compelling content on ganja and its movement globally. I will provide with valuable, informative content that you will appreciate. The content will surely hit your target audience. I will provide you with the work that will be according to the needs of the targeted audience and Google’s requirement.

$55 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Conveyor belt project part 1 - What is a claim of definition - A bicycle is a compound machine - The trouble with wilderness cronon - Https www livescience com 20718 computer history html - Project Schedule, Cost, & Procurement Management - Figurative language poster project - Sleep Journal and Reflection Project, PSYC101 - Unit V journal - English - Practical Connection Assignment - erm - Middle road media case study - Ibm 8202 e4c parts - Diversity and culture - Grams per litre to moles per litre - Statistics chapter 1 homework answers - Discussion Question - I Need Help Completing an Anatomy and Physiology Quiz - The yellow wallpaper quotes about freedom - Unit circle clockwise and counterclockwise - Hegemony james lull - Traditional reporting definition - Stephanie buttermore jeff nippard - Maine coon kittens for sale south australia - The goal book eliyahu m goldratt - Asherah pole in washington dc - Data domain file system cleaning - Case study question - A model for predictive measurements of advertising effectiveness - 22 kv transformer price - What is bonding molecular orbital - Trevor noah james comey youtube - Oxidation reduction reactions lab answers - Toll priority depot nsw - Which of the following is not an outcome of a goods issue to a production order? - IT HOMEWORK - Three phase reactive power - Paper - No objection certificate from employer for attending interview - Racv renew roadside assistance - Religious ethics in public policy - Annotated Bibliography for Persuasive Speech - Sensor switch programming instructions - Worldview & Decision-Making - Closing the knowledge gap is an essential skill for the DNP practice scholar. Reflect upon your application of evidence-based practice and professional formation to consider the following: - Kincaid uses the first person point of view - Diversity - Solubility of a salt lab answers - Genes to organisms mq - Samezu driver's license center - Database redesign is fairly easy when ________ - Google analytics merchandise store demo account - CS - Mackay hose catalogue pdf - How to motivate employees during layoffs - Ancient india travel brochure - Johnny o keefe move baby move - Just prior to awakening chinua from a hypnotic state - What did michael burry study - Who supported the heliocentric model - Ethical issues surrounding corporate governance from a global position - BHS380 Module 3 Discussion Post 3 - Geography Assignment - Bmt tax depreciation melbourne - I shall not pass this way again poem meaning - 400 kb to mb - Balancing chemical equations practice questions - Acid base reaction endothermic or exothermic - Assignment #050 - Research - Online class - Does a red lionfish have a backbone - CJ 1300 MOD 6 Paper - Slavery expanded with the growth of _____ - Fourier transform of pulse function - Chapter 17 preventative maintenance and service procedures - Centor architectural bi folding hardware - Define periodization and its components - To correct error in recording check journal entry - HEALTH INFORMATION SYSTEMS STANDARDS AND SECURITY - How to pronounce daikin - How to put tennis balls in a baseball bathow to put tennis balls in a baseball bat - Reed smith graduate recruitment team - Workcover nsw risk assessment matrix - Health care finance baker pdf - Case study - Bubs early learning centre bega - Sudarshan kriya side effects - Robert haggard attorney ted bundy - The 2014 t6 aluminum rod ac is reinforced - Analyze the behavioral implications of different organizational designs - Powerflex 753 wiring diagrams - J malon southerland aggie leader scholarship - Why cell phones should not be allowed in school - Moses jesus and muhammad similarities - Discussion and reply ( econ& physics) - Profile assignment sample - Danske bank daily withdrawal limit - Student Loan Debt Policy - American chemical society exam