a)

b)

c)

A sample of 20 Automobiles was taken and the miles per gallon (MPG), horsepower (HP), and total weight were recorded. Develop a linear regression model to predict MPG…

1)Using HP as the independent variable. What is the regression equation?

2) Is your model a good predicting equation? How do you know?

3) Using Total Weight as the independent variable, what is the regression equation?

4)Is this a good predicting model? How do you know?

5) Using MPG and Total weight as independent variables, what is the regression equation?

6) Is the model in part e a good predicting equation? How do you know?   

7)  Predict MPG using the model in part e with HP = 100 and weight = 3 thousand pounds.

1. Using SQL, answer the following question referring to the table below
   1. How many twins are there? (Just having the same birthday does not make you twins.)
2. 2. Name the twins.

CREATE TABLE IF NOT EXISTS students (

student_id INT NOT NULL AUTO_INCREMENT,

first_name VARCHAR(16),

last_name VARCHAR(24),

birthday DATE,

street_address VARCHAR(128),

city VARCHAR(32),

PRIMARY KEY (student_id));

INSERT INTO students

(first_name, last_name, birthday, street_address, city) VALUES

('John','Jones','2000-12-17','250 Pines Blvd.','Pembroke Pines'),

('Mark','Bacon','2000-04-12','1270 Walnut St.','Prarie Bluff'),

('Bill','Carlson','1999-07-06','250 Pines Blvd.','Pembroke Pines'),

('Jean','Carlson','1999-07-06','250 Pines Blvd.','Pembroke Pines'),

('Leonard','Cook','2000-09-14','8046 Maple St.','Highland Park'),

('William','Markham','1999-07-06','1600 Sylvan Ln.','Lake Forest'),

('Sam','Cook','1998-10-13','8046 Maple St.','Highland Park'),

('Fred','Williams','1999-07-08','722 Oack Knoll','Arlington'),

('Sally','Fillmore','2000-03-25','1215 Carrington St.','Decatur'),

('Mary','Jones','1999-11-13','1940 Grant St.','Denver'),

('Phyllis','Jones','1999-11-13','1940 Grant St.','Denver');

42-9. Definition of a Security. In 1997, Scott and Sabrina Levine formed Friendly Power Co. (FPC) and Friendly Power Franchise Co. (FPC-Franchise). FPC obtained a license to operate as a utility company in California. FPC granted FPC-Franchise the right to pay commissions to “operators” who converted residential customers to FPC. Each operator paid for a “franchise”—a geographic area, determined by such factors as the number of households and competition from other utilities. In exchange for 50 percent of FPC’s net profits on sales to residential customers in its territory, each franchise was required to maintain a 5 percent market share of power customers in that territory. Franchises were sold to telemarketing firms, which solicited customers. The telemarketers sold interests in each franchise to between fifty and ninety-four A-4 APPENDIX A: ALTERNATE CASE PROBLEMS—CHAPTER 42“partners,” each of whom invested money. FPC began supplying electricity to its customers in May 1998. Less than three months later, the Securities and Exchange Commission (SEC) filed a suit in a federal district court against the Levines and others, alleging that the “franchises” were unregistered securities offered for sale to the public in violation of the Securities Act of 1933. What is the definition of a security? Should the court rule in favor of the SEC? Why or why not? [SEC v. Friendly Power Co., LLC, 49 F.Supp.2d 1363 (S.D.Fla. 1999)]

How do you interpret the price indices in Exhibit 3? How do economists construct them? Use Excel regression to analyze the relationship between the adjusted price index (dependent variable and year (independent variable). Interpret your regression findings by discussing the coefficient of determination (R-squared), the regression coefficient, the regression equation, and the p value.   Can you use the regression equation to predict the price indices? Take into account statistical, macroeconomic, and other considerations.

EXHIBIT 3

This code must be written in Java. This code also needs to include a package and a public static void main(String[] args)

Write a program named DayOfWeek that computes the day of the week for any date entered by the user. The user will be prompted to enter a month, day, and year. The program will then display the day of the week (Sunday..Saturday). The following example shows what the user will see on the screen:

This program calculates the day of the week for any dates.

Enter month (1-12): 9

Enter day (1-31): 25

Enter year: 1998

The day of the week is Friday.

Hint: Use Zeller's congruence to compute the day of the week. Zeller's congruence relies on the following quantities:

J is the century (19, in our example)

K is the year within the century (98, in our example)

m is the month (9, in our example)

q is the day of the month (25, in our example)

The day of the week is determined by the following formula:

h = (q + 26(m + 1) / 10 + K + K / 4 + J / 4 + 5J) mod 7

where the results of the divisions are truncated. The value of h will lie between 0 (Saturday) and 6 (Friday).

Note: Zeller's congruence assumes that January and February are treated as months 13 and 14 of the previous year; this affects the values of K and m, and possibly the value of J. Note that the value of h does not match the desired output of the program, so some adjustment will be necessary. Apply Exception Handling.

The National Basketball League is a professional sports league in North America. Each team in the league must participate the revenue sharing system. For the purposes of the revenue sharing plan, there are no limits to the amount each team may contribute to the plan. Each team is subject to a receipt limits based their designated market area (DMA). For teams with a DMA between 1.5-2.249 households, the final receipt limit is set at 75% of the initial receipt; for a DMA of 2.5-3.249M, the final receipt limit is set at 25% of the initial receipt; for DMAs over 3.25M, the final receipt limit is set at 0%.

If a team rents their arena, items such as fixed signage, temporary signage, and leased luxury suites are included in the plan at 100%. If the team controls their arena with no cotenants, the team must include these items at 70%. For a team that has another professional team as a cotenant, the respective inclusion percentage is 40%. If luxury suites are sold on an individual event-basis, the revenue that is generated from NBL-games is included in the revenue sharing plan at 100% (revenue generated from suite sales to other events are not subject to revenue sharing). Post-season revenues and expenses are excluded from the revenue sharing calculation. Player salary and other expenses are taken at the league average, which were $86M and $7.2M respectively for the 2017-18 year.

Each team in the league plays 82 regular season games a year, half of which are home. The league’s national television deal provides each team with $30M annually in revenue with $500k in associated expenses. Additional league managed items such a licensing provided the teams with $17M in revenue and $3M in expenses. Each team also received a $900k post-season distribution from the league.

If there is no inclusion percentage specified, items are included in the revenue sharing plan at 100%.

Team A

Team A is an arena controller with an NHL cotenant. The team has 3.0M households in their DMA. The team has a related party media deal worth $35M annually which took effect for the 2017-18 season. The fair market value for the media rights has been valued at $40M for the 2017-18 season. The average gate attendance per game was 15,100 people. The team had one of the highest average ticket prices in the league at $103 and a novelties and concession per cap of $7.25. The team’s associated gate expenses were $1.65M and concessions expenses totalled $1.25M. The team also leases 20 suites for a total of $6M per year. Since the team had 5 suites that did not have a lease holder in the 2017-18 season, they were able to sell these unleased suites on a single event basis. Throughout the 2017-18 season, the team generated $1.6M from selling the unleased suites, where $0.9M came from suite sales to NBL games. Fixed signage inventory generated $4M with an 85% margin, while temp signage revenue was $3M with a 90% margin. The team’s main expenses were player salaries ($85M), basketball operations ($15M), G&A ($10M), and other expenses ($2.4M). The team has been in a rebuilding phase and has not qualified for the playoffs the past three seasons.

Team B

Team B is an arena renter. The team has 1.85M households in their DMA. The team signed a local cable deal worth $25M annually. The deal, which took effect for the 2015-16 season, stipulated that the $25M fee was based on the television network broadcasting 60 games. However, the team did not fulfil its obligations as the network only had access to 58 games for 2017-18 so the team’s revenue was adjusted proportionally.

The average gate attendance per game was 13,400 people. The team’s average ticket price in the league was $90 and a novelties and concession per cap of $6.25. The team must pay their concessionaire $2.95 per transaction. The team also leases 22 suites for a total of $6.65M per year. Fixed signage inventory generated $3M with a 75% margin, while temp signage revenue was $4M with a 90% margin. The team has been successful the past few seasons, making it to the second round of playoffs in 2017-18, earning net revenues of $8.6M. The team’s largest expenses were player salaries ($93M), basketball operations ($32M), G&A ($4M), and other expenses ($3.2M). The team also had expenses tied to gate receipts where they had a 90% margin.

Assignment

Based on the information above, first create a P&L for each team for the 2017-18 season. Then apply the revenue sharing plan criteria noted above to determine the P&L amounts subject to revenue sharing.

a. Monopolist faces the following demand curve: P = 510 - 0.7Q; its total cost is given by: TC = 800 + 0.15Q Find marginal cost and marginal revenue

b. Monopolist faces the following demand curve: P = 520 - 0.7Q; its total cost is given by: TC = 800 + 0.3Q Find marginal cost and marginal revenue