This problem is designed to familiarize you with basic Microsoft Excel functions that are commonly used in data analysis and in other Excel problems you will be working in MindTap. You will be using the Microsoft Excel Online file below to work in the spreadsheet and then answer the questions. Feel free to click on the Excel Online link now to open the spreadsheet. It will open in a separate browser tab. Open spreadsheet Column A contains a generic dataset. Column C is a list of questions that correspond to the questions below. Column D indicates which Excel function(s) that question is designed to teach. Column E is where you will work with the function(s) to generate the answer to each question. And finally Column F displays the formula you used to generate your answer in Column E. To place your answers from Column E into the blanks below, use the copy/paste keyboard shortcut: Ctrl C and Ctrl V on a PC or Cmd C and Cmd V on a Mac. If you would like to learn more about a specific function, you can always visit the Microsoft Office Support site and type the function into the search box at the top-right of the page. How many data observations are present (sample size)

Suppose we have a byte addressable computer that has a 32-byte cache with 8 bytes per block. the memory address is 8 bits long. the system accesses memory addresses (in hex) in this exact order: 6e, b9, 17, e0, 4e, 4f, 50, 91, a8, ab, ad, 93, and 94. (a) assuming the cache is direct mapped, what memory addresses will be in cache block 2 after the last address has been accessed? (b) assuming the cache is direct mapped, what is the hit ratio for the entire memory reference sequence given, assuming the cache is initially empty? (c) assuming the cache is 2-way set associative with a lru replacement policy, what is the hit ratio?

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.)

Which of the following is an example of intellectual properly! oa. new version of a novelb. journal of ideasc. pages of a bookood. lines of a poem