1. Suppose that a fire insurance company wants to relate the amount of fire damage in major residential fires to the distance between the burning house and the nearest fire station. The study is to be conducted in a large suburb of a major city. A sample of 14 recent fires in this suburb is selected. The amount of damage, y, and the distance between the fire and the nearest station, x, are given below. We are interested in building a regression model to predict fire damage y, given the distance from the fire x.

1. Is the predictor distance significant? What is the test statistic and p value?
2. What is the amount of variation explained in the model?
3. What is the standard error of the estimated regression line?
4. Use the final regression equation to predict the damage caused by the fire that is 6.5 miles away from the nearest station.

Great Food Restaurants (GFR), is a national chain of restaurants with locations in all 50 states. The GFR relational database consists of nine tables as shown below. Note the following information about GFR and its database:

• Each restaurant has a unique restaurant number.
• Restaurant size is measured in square feet. Restaurant capacity is the number of patrons the restaurant can seat at one time.
• Suppliers supply food to GFR restaurants. Supplier name is unique in the SUPPLIER table.
• GFR has an aggressive marketing campaign in which it tracks each customer as they patronize GFR restaurants. Customer number is unique across the country.
• In the VISIT table, the Bill is the amount of money the customer spent in a particular GFR restaurant on a particular day. Assume that a customer can go to a particular restaurant only once in a given day.
• Employee number is unique across the GFR chain. In terms of employment, GFR is interested in keeping track only of the GFR restaurant that an employee currently works in.
• State names and region names are unique.
• Inspector numbers are only unique within a state.
• Assume that all states score restaurant inspections on the same 1-100 scale.

RESTAURANT

SUPPLIER

FOODDELIVERY

CUSTOMER

VISIT

EMPLOYEE

STATE

INSPECTOR

INSPECTION

There are 6,000 records in the RESTAURANT table.

There are 200 records in the SUPPLIER table.

There are 1.5 million records in the FOODDELIVERY table.

There are 450,000 records in the CUSTOMER table.

There are 15 million records in the VISIT table.

There are 500,000 records in the            EMPLOYEE table.

There are 50 records in the STATE table.

There are 300 records in the INSPECTOR table.

There are 98,000 records in the INSPECTION table.

Questions

1. What would you do to improve the performance of queries to find a customer by name or would you do nothing? Why?

2. What would you do to improve the performance of queries to find a supplier by phone number or would you do nothing? Why?

3. What would you do to improve the performance of queries requiring a list of the complete records of every GFR restaurant in Tennessee together with a list of their employees, including employee number, name, and salary or would you do nothing? Why?

4. What would you do to improve the performance of a query that seeks the salary of the highest paid employee of any GFR restaurant in Tennessee or would you do nothing? Why?

Write a python or java code which can calculate the Shapely-Shubik and Banzhaf indices to determine which state in America has the most power in the primary election.

Regarding theft crimes, explain in ONE page, why Florida law has so many theft statutes, and so many different sentences for such crimes as theft from the elders, or identity theft, or purse snatching versus sudden snatching, etc.

Timing-Waiting Lines

Joe Hammer is thinking about setting up a special counter for the do-it-yourself customers at which they can get, not only help where to find products in the store, but also some quick advice about the best way to handle their upcoming projects. Experience has taught Joe that six minutes is a good figure to allow for the average time required to serve a “do-it-yourselfer” and that these customers will arrive every 15 minutes throughout the day.

a.) If joe sets up the counter under these conditions, what operating characteristics might he expect?

b.) What might Joe do to avoid the costs of idleness?

c.) What is the likelihood(probability) that three or more customers will be at the counter, either waiting or being served, at any given time?

Calculate the Utilization rate, idleness rate, Average time in queue, Average time in system, Average number in queue, Average number in system, and probability that three or more customers will be in the counter system at the same time.

What is the silver ion concentration in a solution prepared by mixing 335 mL of 0.386 M silver nitrate with 419 mL of 0.410 M sodium carbonate? The Ksp of silver carbonate is 8.1 × 10-12

Python: Write a function named power() that calculates rootpow recursively. It receives two arguments root (float) and pow (int) > = 1, and it returns the result root raised to power pow. The recursion of the power function is defined as: Base case: rootpow = root, if pow = 1 Recursive case: rootpow = root* rootpow-1 , otherwise. b) Develop a greatestC( ) function that determines the greatest common divisor of two integer numbers. Test greatestC() in a simple main program on the following numbers: 12 and 24; 50 and 10; 33649 and 17043. The recursive definition of the gcd function is as follows: Base case: greatestC(x, y) = x if y = 0 Recursive case: greatestC(x, y) = greatestC(x, x % y) otherwise, where % is the modulus operator.

Research Enterprise Rent a Car company and its leadership team.

1.- what are the company’s strengths and weaknesses?

2.- Who is its main competitor and how do they market themselves?

3.- Who is there target customer audience?

4.-Create a Leadership Development Program that can be used for their domestic and international employees.

5.- explain the dynamics of this company.

the best document to use to obtain information in order to make a decision on a system. As a systems analyst, explain to management the two types of documents available and what they are used for

Write a two (2) page report on the recent space travel by NASA and SpaceX.
Explain any four electronics subsystems involved. (present in pdf or type)

• Simultaneous TCP connection initiations are rare, but simultaneous connection termination is relatively common. How do two TCP nodes negotiate the simultaneous sending of FIN packets to one another? Draw the ladder diagram, and label the states on each side. Which node goes into TIMEWAIT state?

Pension plan was adopted on Jan 1 2018, all employees were granted benefits for prior serviced. This created PBO of $205,352. Company immediately contributed $155,000 to the plan. In 2018 Company provided additional funds of $130,000. Interest was outstanding all year long, and accrued at 4%. Return on planned assets invested in January was expected to approximate 8%. The plan is administered by trust department of regional bank. The planned assets are invested in exchange-listed equity securities 40%, corporate bonds 15% and U.S. government bonds 45% There is an expected rate of compensation increase of 5 %, yet the rate did not happen this year. Compute pension expense.

Describe social and emotional development during middle childhood, including facts about Erikson’s stage of development and the conflict to be mastered, self- concept, social cognition, and social interactions /friendships with peers.

Describe the characteristic of your community and explain the type of segmentation you would use to segment the market appropriately.

b. Develop a retail format targeting the market and discuss how you would use the mix in achieving your objective.