Algebra Worksheet Essay
Algebra Worksheet Essay
ORDER NOW FOR CUSTOMIZED AND ORIGINAL ESSAY PAPERS
Please answer directly on the worksheet. also please review the scoring guide on the first tab of the spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion. Please review scoring chart on first slide of excel. I live in McDowell County, WV and will be traveling to Miami Florida with 6 friends (that should answer the questions needed for assignment). Thank you tremendously! Grand Canyon University MAT 144 Algebra Worksheet
1attachments
Slide 1 of 1
attachment_1attachment_1
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 9 the entire group with an Excel formula Lodging Expenses identified and calculated for the entire group with an Excel formula Food Expenses identified and calculated for the entire group with an Excel formula Entertainment Expenses identified and calculated for the entire group with an Excel formula Total Budget Budget Expenses total 9 9 9 7 45 0 Loans Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED. Possible Points Points Earned Comments PMT Calculation 12 Total cost of Loan 6 Total Interest Paid 4 Explain in 25 to 100 words which loan is the 8 best option and why. Question 2 total 30 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 9 Range, Minimum, Maximum 9 Standard Deviation 4 z-Score 4 Set up of Bins (Low and High Formulas) 8 Frequency Columns 8 Histogram 8 Stats total 50 0 Major Assignment 1 Total for Major Assignment 1 125 0 Location Transportation Item Description Qty Price each numbers Number or NA Total price Formulas Source Link or citation Total price Formulas Link or citation Total price Formulas Link or citation (Add rows as needed) Lodging Item Description Qty Price each numbers Number or NA (add rows as needed) Food Item Description Qty Price each numbers Number or NA (add rows as needed) Entertainment and Misc. Item Numbers (add rows as needed) Qty Price each numbers Number or NA Total price Formulas Link or citation Input Name Here Formula Required Number/Text Budget Total: Each cell is color coded as indicated to the left. The ce will change to grey after it has been completed. formula 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 (input in Cell D2) and then determine the total costs (for everyone going) – 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. Grand Canyon University MAT 144 Algebra Worksheet
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. d as indicated to the left. The cell y after it has been completed. Formula Required Number/Text Loans Loan A Principal (P) (same for both loans) number rate ( r) number # of Compoundings per year (n) number time in years (t) number Payment (PMT) formula Loan B number number number number formula Total Paid Interest Paid Source formula formula Link or citation formula formula Link or citation Suppose you all decide you want to finance a good source). Make sure the interest rate monthly payment amount, the total amoun pay. NOTE: You can find loan rates on maj information, feel free to use one of the lin Loan payment formula: PMT = P*(r/n)/(1 – PMT is the payment required to pay off a lo You must use Excel formulas including cell paid. Discuss which loan would be a better option and why: (8 points!) ou all decide you want to finance the trip with a loan. Find two different available offers (the internet is rce). Make sure the interest rate and loan length are both different in each option. Calculate the ayment amount, the total amount you will pay over the life of the loan and the total interest you will E: You can find loan rates on major bank and credit union websites without providing personal n, feel free to use one of the links here. ent formula: PMT = P*(r/n)/(1 – (1 + r/n)^(-n*t)) payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years. use Excel formulas including cell references to calculate the loan payment, total paid and interest er option and why: (8 points!) Link to Credit Card Inter NerdWalle Credit Karm Top10Personal Link to Credit Card Interest Rate Source NerdWallet Credit Karma Top10PersonalLoans Height Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Input name below to generate the data Full Name Formula Required Number/Text Descriptive Statistics Mean Median Mode Range Minimum Maximum Standard Deviation Your height (in inches) z score for your height Bin Width formula formula formula formula formula formula formula number formula Histogram – Bin width formula The Height Data is named height, use this name in your formu Low formula formula formula formula formula formula formula formula formula formula formula High formula formula formula formula formula formula formula formula formula formula formulaGrand Canyon University MAT 144 Algebra Worksheet
(remem Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data ght Data is named height, you may e this name in your formulas. Frequency Distribution Bins Cumulative Frequency auto formula auto formula auto formula auto formula auto formula auto formula auto formula auto formula auto formula auto formula auto formula (remember to create the Histogram, too). Histogram Here Frequency formula formula formula formula formula formula formula formula formula formula formula Using the randomizing data set of 102 heig Excel formulas with cell references find the Statistics: • Mean • Median • Mode • Range • Minimum • Maximum • Standard deviation • The z score for your height (use the com standard deviation) Also, using Excel formulas with cell referen following: • Frequency distribution • Histogram – Create a Graphical Represe andomizing data set of 102 heights provided and using ulas with cell references find the following Descriptive n um um rd deviation core for your height (use the computed mean and eviation) Excel formulas with cell references complete the ncy distribution am – Create a Graphical Representation of the Data
0 comments