In Assignment 1, you created a weekly budget for your family and in Assignment 2, you added various formats to the spreadsheet. In this assignment, you will add some analysis to your budget. Open the last assignment, and save it as Weekly_Budget_3_Your_Name. Instructions 1. For each family member in your budget, calculate the total amount spent. In Cell A14, place the title “Total Spent.” • In cells B14 through E14, place the correct formula that will calculate how much money each family member spent. (Hint: You will have a separate number for each family member.) 2. For each family member in your budget, calculate the number of expenses each family member had (you will use the =COUNT function for this). In Cell A15, place the title “Number of Expenses.”  In cells B15 through E15 place the correct formula that will calculate how many items each family member spent money on. 3. For each expense item, calculate the total amount spent on that item. In Cell F3, place the title “Item Total.”  In cells F4 through F13, place the correct formula that will calculate how much money was spent on each expense item. 4. For each expense item, calculate the number of family members that have this expense (you will use the =COUNT function for this). In Cell G3, place the title “# of Times Used.”  In cells G4 through G13, place the correct formula that will calculate how many times each expense was used. 5. Calculate the total Expense. In Cell D16, place the title “Total Spent.”  In Cell E16, place the correct formula that will calculate the total spent for the entire family. 6. Make sure the layout of your spreadsheet is neat and clear, by adjusting the borders to include the new information.

1. package newton’s method for approximating square roots (case study 3.6) in a function named newton. this function expects the input number as an argument and returns the estimate of its square root. the script should also include a main function that allows the user to compute square roots of inputs until she presses the enter/return key. 2. convert newton’s method for approximating square roots in project 1 to a recursive function named newton. (hint: the estimate of the square root should be passed as a second argument to the function.) 3. elena complains that the recursive newton function in project 2 includes an extra argument for the estimate. the function’s users should not have to provide this value, which is always the same, when they call this function. modify the definition of the function so that it uses a keyword parameter with the appropriate default value for this argument, and call the function without a second argument to demonstrate that it solves this problem. 4. restructure newton’s method (case study 3.6) by decomposing it into three cooperating functions. the newton function can use either the recursive strategy of project 1 or the iterative strategy of case study 3.6. the task of testing for the limit is assigned to a function named limitreached, whereas the task of computing a new approximation is assigned to a function named improveestimate. each function expects the relevant arguments and returns an appropriate value. 5. a list is sorted in ascending order if it is empty or each item except the last one is less than or equal to its successor. define a predicate issorted that expects a list as an argument and returns true if the list is sorted, or returns false otherwise. (hint: for a list of length 2 or greater, loop through the list and compare pairs of items, from left to right, and return false if the first item in a pair is greater.)

Some of the first computer games were created in the early 1970s by college students experimenting after hours to see what the were capable of doing.

Technician a says that a dry sump system uses no oil storage sump under the engine. technician b says that a wet sump system uses no oil storage sump under the engine. who is correct?