Reference no: EM133218016
Question: Select an organization or publicly-traded company and locate a relevant data set (sales, revenue, etc.). Apply the concepts covered during the week (COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions) to a use case with real-world data for a business or organization.
Provide a brief explanation of your data, the business or organization, and the use case.
Once you have chosen a data set and organization, apply functions to demonstrate the use case. Please include a summary :
Provide an overview of your data, business/organization, and use case
Analyze the data and give reasoning of why you think it is useful to the business or organization.
Articulate what Excel functions you have used and apply it to the dataset to demonstrate it.
|
Compute the checksum as tcp/ip does
: See if you can compute the checksum as TCP/IP does. Run the applet, using any message. Select a data packet, but don't select the last packet because it might
|
|
What would be an obvious way to decrease the overhead
: How many characters in total (and to your best estimate) would be sent in all packets necessary to move it from node 0 to node 1?
|
|
Four rules for credit rating and each customer
: Enter formulas/functions for rules 1-4 in columns I, J, K, and L respectively. These formulas will demonstrate if the customer credit is approved based on each
|
|
Evaluate various platforms for characteristics
: Evaluate various platforms for characteristics, advantages, and weaknesses for hosting a web-based software application. Consider the following in your
|
|
Provide an overview of your data
: Provide an overview of your data, business/organization, and use case Analyze the data and give reasoning of why you think it is useful to the business
|
|
Draw a deterministic and non-deterministic finite automate
: Draw a deterministic and non-deterministic finite automate which accept AA and BB at the end of a string containing A, B in it, e.g., ABABABAA but not AAABBBABA
|
|
Design an algorithm that outputs the time-stamps
: Design an algorithm that outputs the time-stamps in the correct order and uses only a constant amount of storage, i.e., the memory used should be independent
|
|
Describe what are the sub-problems here
: Describe what are the sub-problems here and what is the size/count of sub-problems and Describe which inputs to the knapsack problem (value and size)
|
|
Average wages of females
: Does the earnings gap between the average wages of females and the average wages of males prove labor market discrimination? Why or why not?
|