Using the information from the following scenario, conduct a one-way ANOVA and specify the LSD post hoc test.

Scenario

The superintendent is continuing to examine the data that has been reported for the district. Another question concerned the differences in performance on high stakes tests. To examine this issue, the superintendent obtained the average scale scores for schools that participated in the high stakes testing for the district and two comparison districts. The following scores were collected:

Questions

1. What is the mean scale score for each district?

Superintendent’s District=314.71

Comparison District 1=301.29

Comparison 2=297.86

2. What is the standard deviation of the scale scores for each district?
3. State an appropriate null hypothesis for this analysis.
4. What is the observed or computed value of F?
5. What are the reported degrees of freedom for the Between Groups variance?
6. What are the reported degrees of freedom for the Within Groups variance?
7. What is the reported level of significance?
8. Based on the results of the one-way ANOVA, would you accept or reject the null hypothesis?
9. Based on the results of the LSD post hoc test, identify which districts are significantly different.
10. Present the results as they might appear in an article. This must include a table and narrative statement that reports the results of the one-way ANOVA and LSD post hoc test.

Note: The table must be created using your word processing program. Tables that are copied and pasted from SPSS are not acceptable.

Must be coded in python.

Consuming A Web Service with Python

Consuming data from programmable web based API’s is growing rapidly. According to ProgrammableWeb, in just six years (2010-2016), web API counts increased 758 percent with the majority being REST based. This is driven by a myriad of factors but growth of cloud based applications, (distributed computing by another name), and the resulting need to integrate the different categories is a major factor.

Description

Write a client to consume a REST web service of you choice using Python. There are many listings of such services but an excellent resource is ProgrammableWeb. Your information should produce useful information. I.e. a dump of cryptic data is not the desired product. Examples could be a weather forecast, stock quote, Bible verse, etc.,

Your solution should present the user with a question with the answer contributing to the data used in the REST web service call. For example, a weather forecast would prompt the user to enter a zip code or other location information. Once the web transaction is complete, the program should prompt again with the same question to complete another transaction. This should continue until the user enters a specified termination condition.

You output must be presented in an understandable manner. Dumps of XML, JSON, etc., are substandard and will be graded accordingly.

Hint:

Be sure to click on the examples and look at the address bar of your browser. That is what you will need to generate with the Python requests module.

You are free to use any REST web service you find but I recommend this one if you are looking for something straightforward. One word of caution, some services require you to request access via an API key. The approval may not be immediate so you will want to find something sooner rather than later. The example I listed above requires no approval.

Please submit SQL statements as a plain text file (.txt). If blackboard rejects txt file you can submit a zipped file containing the text file. Word, PDF, or Image format are not accepted. You do not need to show screen shot. Make sure you have tested your SQL statements in Oracle 11g.

The list of tables is:

Tables:

Cust Table:

cid, -- customer id

cname, --- customer name

cphone, --- customer phone

cemail, --- customer email

Category table:

ctid, --- category id

ctname, --- category name

parent, --- parent category id since category has a hierarchy structure, power washers, electric power washers, gas power washers. You can assume that there are only two levels.

Tool:

tid, --- tool id

tname, --- tool name

ctid, --- category id, the bottom level.

quantity, --- number of this tools

Time_unit table allowed renting unit

tuid, --- time unit id

len, --- length of period, can be 1 hour, 1 day, etc.

min_len, --- minimal #of time unit, e.g., hourly rental but minimal 4 hours.

Tool_Price:

tid, --- tool id

tuid, --- time unit id

price, -- price per period

Rental:

rid, --- rental id

cid, --- customer id

tid, --- tool id

tuid, --- time unit id

num_unit, --- number of time unit of rental, e.g., if num_unit = 5 and unit is hourly, it means 5 hours.

start_time, -- rental start time

end_time, --- suppose rental end_time

return_time, --- time to return the tool

credit_card, --- credit card number

total, --- total charge

Problem . Insert at least three rows of data to each table above. Make sure you keep the primary key and foreign key constraints. [20 points]

• Given the pseudocode for Binary Search Algorithm as below:

BinarySearch(A, p, r, V)

   if p < r

q = (p + r)/2

if V = A[q]

return q

else if V > A[q]

return BinarySearch(A, q+1, r, V)

   else return BinarySearch(A, p, q-1)

else if p = r,

   if V = A[p]

   return p

else

return -1

   return -1

end function

Using this pseudocode, write a function for BinarySearch and also complete the program, by writing a main, which will supply the array A (you may like to use the same main as the other programming exercise you have done so far), and also get an user input for V (which should have same data type as the array itself).

Call the function BinarySearch by sending the array, and 1 for p, N for r and V, store the value in a variable x, which stores the position number of the searched key V.

Then check if x is -1, then display data is not found, otherwise display the value of x, by using a suitable title, saying Data V is found in location x (value of x should be displayed).

Must compile, run and copy and paste the program underneath this word document.

2. a) Construct a Binary Search Tree using the following data:

54 37 17 28 44 71 64 60

b) Illustrate how will you search for 30 from the above tree and how many searches will be needed.

c) Illustrate how you will delete the root from the above tree, redraw the tree after deletion.

d) Add a new data after conducting operation c, say the new value = 50

(Do not start from scratch, show this operation by adding onto existing Tree).

e) Write down the pre-order, post-order and in-order traversal.

MUST BE WRITTEN IN ASSEMBLY LANGUAGE ONLY AND MUST COMPILE IN VISUAL STUDIO

You will write a simple assembly language program that performs a few arithmetic operations. This will require you to establish your programming environment and create the capability to assemble and execute the assembly programs that are part of this course.

Your \student ID number is a 7-digit number. Begin by splitting your student ID into two different values. Assign the three most significant digits to a variable called 'left' and the four least significant digits to a variable called 'right'.

You must choose the data type that is appropriate for the range of decimal values each variable can store. You will choose a data type when you define each of the variables in your program. Try to make efficient use of memory.

Calculate the sum of the two variables 'left' and 'right'. Store this result in a variable called 'total'.

Calculate the positive difference between the variables 'left' and 'right'. Store this result in a variable called 'diff'.

Define a character string called 'message' that contains the characters, "Hello world!".

Define an array of data type WORD called 'Array' that is initialized to the following values: 1, 2, 4, 8, 16, 32, and 64.

Write assembly language code using what you know so far (do not look ahead in the book just yet) to determine the length of 'Array'. Store this value in a variable called 'ArrayLength'.

Move the contents of the variable 'left' into the EAX register.

Move the contents of the variable 'right' into the EBX register.

Move the contents of the variable 'total' into the ECX register.

Move the contents of the variable 'diff' into the EDX register.

Move the contents of the variable 'ArrayLength' into the ESI register.

Call the author's DumpReg routine to display the contents of the registers.

As a summer intern in the Marketing Department of Jovanovic Laboratory Supply, Inc, in Bozeman, Montana, you have been working on the company's annual catalog. You notice that staffers could save a lot of valuable time by copying and inserting images and text from the old edition into the new document. You've been asked to draft a memo to describe the procedure of copy and pasting pictures and text from PDF documents.Create an instructional memo on how to copy and pictures and text from PDF documents. Read the original steps below and revise it so that the steps described below are in abbreviated form, and arrange all necessary instructions in logical sequence. Ensure that the steps are clear and easy to follow. The memo should be addressed to "Marketing Department Staff" members and signed by you.

How to copy and paste images and text from PDF documents: You start by viewing the Edit pull-down menu in an open PDF document. Depending on the Acrobat version, a feature called Take a Snapshot can be seen. It is preceded by a tiny camera icon and a check mark when the tool is activated. To copy content, you need to select the part of the PDF document that you want to capture. The cursor will change its shape once the feature is activated. Check what shape it acquires. With the left mouse button, click the location where you want to copy a passage of image. At the same time, you need to drag the mouse over the page in the direction you want. A selected area appears that you can expand and reduce, but you can't let go of the left mouse button. Once you release the left mouse button, a copy of the selected area will be made. You can then paste the selected area into a blank Microsoft Office document, whether Word, Excel, or Powerpoint. You can also take a picture of an entire page, if needed.

Question 4: Freefall

Belugaland is a small economy whose primary product is caviar: which is the French word for “smelly fish eggs”.

Unfortunately for Belugaland, meteorologists identify an adverse weather pattern named “El Noono, the midnight

sun” that may hit the country in the future. When it comes, El Noono will heat up the ocean and kill all the smelly

fish that lay the smelly eggs thus inevitably destroying the income of the Belugans. Faced with the possibility of

a fall in future income the Belugan people lose confidence in the future and cut back on their consumption of all

goods. Furthermore, investors become wary of starting factories that can produce fish-eggs resulting in a fall in

investment as well. Assume that the economy is currently at Y* and answer the following questions. [When you

answer these questions, you can ignore the actual impact of El Noono when it hits the economy in the future,]

a) Use an AD/IA diagram show what happens in the short run and in the long run when the Belugans cut back

on their consumption and investment spending.

b) The leader of Beluga, King Salamander, who used to be an accountant, raises taxes to make sure the gov-

ernment budget is balanced. Using the AD/IA diagram you drew in a) show the long-term impact of an increase in

taxes on Belugaland’s already battered economy.

c) If you were King Salamander’s trusted financial advisor what fiscal policy/policies would you recommend

instead of increasing taxes? Graphically describe how this would help increase output in Belugaland.

d) If you were King Salamander’s top central banker, what monetary policy would you pursue (ignoring the

possibility of a fiscal policy response)? Graphically describe how this would help increase output in Beluga.

Please reply to this post by a classmate. 150 words minimum.

Let me start with my weakness in writing. I feel like one of my weakness is imprecise and incorrect word choices. I know this can confuse the reader, so this is something that I have been working on. Another weakness is redundancy and wordiness now this is something that I didn't realize that I was doing until it was brought to my attention by one of my teachers. However, with both weakness I have been working hard to correct these issues. And my strengths are my love to read and my commitment to learning I get excited when I learn new things.

Professional writing is important in a supervisory position great writing skills for reports and feedback for employees. It is important that documents and accurate. Communication come in many different forms however, writing notes, emails, memos and letters are all require. And when a people does not have this type of skill this may come across as having a lower level of intelligence. Good writing skills in the workplace helps a business in several ways. Having this type of skill helps open doors and help one work towards their goals and it also helps one become more clear and concise and allow one to stand out as compared with the rest.

My professional email skills can use some real work after reading module 13 I was able to learn somethings that I should change in my commutation of email. The point of email etiquette is that it helps streamline communication. And now that we all are dealing with the coronavirus pandemic we are using email as a main line of communication in order to keep everyone safe during this time. The one error I see more than any thing is flaming, most of the time people use emails as a tool to create a hostile environment.

Using the Balance Sheet and Income Statement data below, analyze the transactions for Tolito Treats, Inc. for 2013 and 2014.

Additional data for the period January 1, 2014 through December 31, 2014 are:

Sales on account, $70,000.

Purchases on account, $40,000.

Depreciation, $5,000.

Expenses paid in cash, $18,000 (including $4,000 of interest and $6,000 in taxes).

Decrease in inventory, $2,000.

Sales of fixed assets for $6,000 cash; cost $21,000 and two-thirds depreciated (loss or gain is included in income).

Purchase of fixed assets for cash, $4,000.

Fixed assets are exchanged for bonds payable of $30,000.

Sale of investments for $9,000 cash.

Purchase of treasury stock for cash, $11,500.

Retire bonds payable by issuing common stock, $10,000.

Collections on accounts receivable, $65,000.

Sold unissued common stock for cash, $1,000.

In Excel, prepare a statement of cash flows (indirect method) for the year ended December 31, 2014.

In Excel, prepare a side-by-side comparative statement contrasting two bases of reporting: (1) net income and (2) cash flows from operations.

Which of the two financial reports in (b) better reflects profitability? Explain in one paragraph in Word or using a comment box in Excel.