In this quiz, use the following touchdown data for Tom Brady:

2 (a) Find the correlation coefficient, accurate to four significant figures, between the number of touchdowns, t, and the number of passing yards, y.

(b) Find the equation of the regression line, y = n*t + k, giving the line of best fit for the number of passing yards, y, as a function of the number of touchdowns, t. What is the slope, n, of this line, accurate to two decimal places?

(c) Find the equation of the regression line, y = n*t + k, giving the line of best fit for the number of passing yards, y, as a function of the number of touchdowns, t. What is the value of k for this line, accurate to two decimal places?

(d)  Use the regression line you found in 2 (b) and 2 (c) to find the number of touchdowns expected if Brady passes for 4000 yards.Use the values stored in your calculator or spreadsheet, without rounding them, and give an answer with four significant figures.

(e) Use the regression line you found in 2 (b) and 2 (c) to find the number of passing yards expected if Brady throws 45 touchdowns.Use the values stored in your calculator or spreadsheet, without rounding them, and give an answer with two decimal places.

Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals.

(a) Based on the ANOVA table and t-statistics, does the regression appear significant?

(b) Calculate the Durbin-Watson Test statistic. Is there a serial correlation problem with the data? Explain.

(d) What affect might your answer in part (b) have on your conclusions in part (a)?

Can you please give detailed steps to do on excel?

Program Requirements:

Write a C++ program according to the following requirements:

1.   Open the data file Electricity.txt and read each column into an array (8 arrays total).

2.   Also create 2 arrays for the following:

• Total Fossil Fuel Energy (sum of all fossil fuels)
• Total Renewable Energy (sum of all renewable sources)

Electricity.txt:

Net generation United States all sectors monthly
https://www.eia.gov/electricity/data/browser/
Source: U.S. Energy Information Administration
All values in thousands of megawatthours
Year   all fuels   coal       natural gas   nuclear       hydroelectric   wind       solar
2018   347576.0   95496.8       122393.9   67257.0       24377.0       22720.8       7780.4
2017   336189.2   100486.3   108034.6   67079.1       25027.8       21191.9       6439.7
2016   339722.9   103262.4   114858.9   67141.2       22317.7       18916.0       4572.2
2015   339800.1   112699.8   111123.5   66431.5       20756.7       15893.2       3252.7
2014   341133.8   131809.2   93884.1       66430.5       21613.9       15137.9       2410.3
2013   338830.3   131759.6   93736.3       65751.4       22380.4       13986.6  
2012   337313.8   126170.2   102157.8   64110.9       23020.0       11735.1  
2011   341678.4   144452.5   84474.1       65850.4       26612.9       10014.7  
2010   343755.0   153940.9   82308.1       67247.4       21683.6       7887.7  
2009   329194.2   146325.4   76748.2       66571.2       22787.1       6157.2  
2008   343282.3   165483.4   73581.7       67184.0       21235.9       4613.6  
2007   346395.4   168038.0   74715.8       67202.1       20625.8       2870.8  
2006   338725.2   165875.9   68036.7       65601.6       24103.9       2215.8  
2005   337951.9   167739.4   63413.4       65165.5       22526.8       1484.2  
2004   330879.6   164858.4   59175.0       65710.7       22368.1       1178.6  
2003   323598.8   164478.1   54159.0       63644.4       22983.9       932.3  
2002   321537.7   161094.2   57583.8       65005.3       22027.4       862.9  
2001   311387.0   158663.0   53260.8       64068.9       18080.1       561.4

Cintas designs, manufactures, and implements corporate identity uniform programs that it rents or sells to customers throughout the United States and Canada. The company’s stock is traded on the NASDAQ and has provided investors with significant returns over the past few years. Selected information from the company’s balance sheet follows. For 2012, the company reported sales revenue of $3,708,400 and cost of goods sold of $1,516,015. CINTAS Balance Sheet (in thousands) 2012 2011 Cash $ 35,373 $ 38,927 Marketable securities — 202,542 Accounts receivable 408,884 389,918 Inventories 231,752 198,019 Prepaid expense and other 15,797 15,797 Accounts payable 64,624 71,642 Accrued compensation and related liabilities 70,769 95,381 Accrued liabilities 263,516 239,067 Accrued tax liability 2,568 — Long-term debt due within one year 4,155 26,667 Required: Compute the current ratio, inventory turnover ratio, and accounts receivable turnover ratio (assuming that 70 percent of sales were on credit). (Round your answers to 1 decimal place.)

What is the:

current ratio?

Inventory turnover ratio?

Accounts recieveable turnover ratio?

Create a class called MovieReducerExtremes that implements MediaReducer. Implement a reducer that takes a movie list and an option ("newest" or "oldest"), then return the newest or oldest movie as appropriate.Submit both the MovieReducerExtremes and the Movie class from the first question.

/////Required Output:///////

Newest\n
 2014 AKA Jessica Jones                                       Action         \n
Oldest\n
 1936 Cabaret                                                 Music          \n

Given Files:

Movie.java

public class Movie extends Media {
    public Movie(String name, int year, String genre) {
        super(name, year, genre);
    }

    public String getEra() {
        if (getYear() >= 2000) {
            return "New Millennium Era";
        } else if (getYear() >= 1977) {
            return "Modern Era";
        } else if (getYear() >= 1955) {
            return "Change Era";
        } else if (getYear() >= 1941) {
            return "Golden Era";
        }

        return "Pre-Golden Era";
    }

    public boolean wasReleasedAfter(Media other) {
        return getYear() > other.getYear();
    }

    public boolean wasReleasedBeforeOrInSameYear(Media other) {
        return getYear() <= other.getYear();
    }
}

Demo3.java

import java.io.FileNotFoundException;
import java.util.ArrayList;

public class Demo3 
{

    public static void main(String[] args) throws FileNotFoundException {

        ArrayList movies = MovieLoader.loadAllMovies();

        MediaReducer op = new MovieReducerExtremes();

        System.out.println("Newest");
        System.out.println(op.reduce(movies, "Newest"));
        System.out.println("Oldest");
        System.out.println(op.reduce(movies, "Oldest"));
    }
}

Media.java
public abstract class Media {
    private String name;
    private int year;
    private String genre;

    public Media(String n, int y, String g) {
        name = n;
        year = y;
        genre = g;
    }

    public String getName() {
        return name;
    }

    public int getYear() {
        return year;
    }

    public String getGenre() {
        return genre;
    }

    public String toString() {
        return String.format("%5d %-55s %-15s", year, name, genre);
    }

    //if the media was released on or after the year 2000, return New Millennium Era
    //if the media was released on or after the year 1977, return Modern Era
    //if the media was released on or after the year 1955, return Change Era
    //if the media was released on or after the year 1941, return Golden Era
    //in any other situation, return Pre-Golden Era
    public abstract String getEra();

    //return true if this media has a greater release year than the other's
    public abstract boolean wasReleasedAfter(Media other);

    //return true if this media was a lesser or equal release yearn than the other's
    public abstract boolean wasReleasedBeforeOrInSameYear(Media other);
}

MovieLoader.java

import java.io.File;
import java.io.FileNotFoundException;
import java.util.ArrayList;
import java.util.Scanner;

public class MovieLoader {
    public static ArrayList loadAllMovies() throws FileNotFoundException {
        File f = new File("movie_list.txt");
        Scanner inputFile = new Scanner(f);
        ArrayList result = new ArrayList<>();
        while (inputFile.hasNextLine()) {
            String name = inputFile.nextLine();
            int year = inputFile.nextInt();
            //skip new line
            inputFile.nextLine();
            String genre = inputFile.nextLine();
            Media m = new Movie(name, year, genre);
            result.add(m);
        }
        return result;
    }
}

MediaReducer

import java.util.ArrayList;

public interface MediaReducer {
    public String reduce(ArrayList list, String key);
}

A couple from the movie_list.txt

!Next?
1994
Documentary
#1 Single
2006
Reality-TV
#ByMySide
2012
Drama
#Follow
2011
Mystery
#nitTWITS
2011
Comedy
$#*! My Dad Says
2010
Comedy
$1,000,000 Chance of a Lifetime
1986
Game-Show
$100 Makeover
2010
Reality-TV
$100 Taxi Ride
2001
Documentary
$100,000 Name That Tune
1984
Game-Show
$100,000 Name That Tune
1984
Music
$2 Bill
2002
Documentary
$2 Bill
2002
Music
$2 Bill
2002
Music
$2 Bill
2002
Music
$2 Bill
2002
Music
$25 Million Dollar Hoax
2004
Reality-TV
$40 a Day
2002
Documentary
$5 Cover
2009
Drama
$5 Cover: Seattle
2009
Drama
$50,000 Letterbox
1980
Game-Show
$9.99
2003
Adventure
$weepstake$
1979
Drama
' Horse Trials '
2011
Sport
'80s Videos: A to Z
2009
Music
'Allo 'Allo!
1982
Comedy
'Allo 'Allo!
1982
War
'Conversations with My Wife'
2010
Comedy
'Da Kink in My Hair
2007
Comedy
'Da Kink in My Hair
2007
Drama
'More strasti'
2000
Romance
'Ons Sterrenkookboek'
2007
Documentary
'Orrible
2001
Comedy
'Orrible
2001
Crime
'Orrible
2001
Drama
'S ann an Ile
2009
Documentary
'Sang linggo nAPO sila
1995
Game-Show
'Sang linggo nAPO sila
1995
Musical
'T Wilhelmina
1975
Comedy
'Til Death Do Us Part
2006
Crime
'Til Death Do Us Part
2006
Drama
'Til Death Do Us Part
2006
Fantasy
'Til Death Do Us Part
2006
Romance
'Til Death Do Us Part
2006
Thriller
'Til Death
2006
Comedy
'Untold
2004
Documentary
'Wag kukurap
2004
Horror
'Way Out
1961
Drama
'Way Out
1961
Horror
'Way Out
1961
Sci-Fi
'n Shrink
2009
Comedy
't Is maar TV
1999
Comedy
't Is maar TV
1999
Game-Show
't Is maar een spel
2002
Comedy
't Is maar een spel
2002
Game-Show
't Schaep Met De 5 Pooten
1969
Comedy
't Schaep Met De 5 Pooten
2006
Comedy
't Schaep Met De 5 Pooten
2006
Drama
't Zal je gebeuren...
1998
Drama
't Zonnetje in huis
1993
Comedy
(S)truth
1999
Drama
+ Clair
2001
Documentary
+ Emprendedores mi+d
2010
Documentary
+ Investigadores
2008
Documentary
+ de cin�ma
2001
Documentary
+ de cin�ma
2001
News
... ins Gr�ne! Das Stadt-Land-Lust-Magazin
2010
Documentary
... und basta!
2006
Comedy
... und basta!
2006
Music
... und die Tuba bl�st der Huber
1981
Comedy

AT&T is the second-largest provider of mobile telephony and the largest provider of fixed telephony in the United States, and also provides broadband subscription television services.

The CEO of AT&T wants to know what will affect the Total Monthly Spending at AT&T (y) for a customer. So far, the company has information on customer’s age (X1). We have total 50 observations.

1). Using the knowledge you learned from Chapter 3 to summarize the Total Monthly Spending at AT&T and customer’s age. What are the characteristics of this sample?

2). Determine the simple linear regression equation and interpret the slope

3) What is the goodness of fit of this model? Interpret the statistic.

4). At the 0.05 level, test the slope of the regression model. Write down 4-step. Do you think customer’s age will significantly affect the Total Monthly Spending at AT&T?

5). what is the 95% confidence interval for the slope? How does it tell you about the significance of the slope? Does this conclusion agree with the conclusion from 4)

6). What is the estimated average Total Monthly Spending at AT&T for 25 years old customers?

7). Calculate the prediction interval of the Total Monthly Spending at AT&T for a 25 years old customer (Show your calculation details in Excel). Interpret the results. (α=0.05)

8). Calculate the confidence interval for the mean of the Total Monthly Spending at AT&T for 25 years old customers (Show your calculation details in Excel). Interpret the results. (α=0.05

9). Comparing results from 7) and 8), which one is wider? Why?

10). Calculate SSR, SSE and SST for this model.

Evaluating customer profitability

You own a credit card company. You want to evaluate the profitability of customers A and B.

The only source of revenue from customers is the interest that you charge on credit card balances. You charge customers an interest rate of 10%. Thus, if the credit card balance is $1,000, revenue is $1000*0.1=$100.
Variable costs are zero for simplicity. From your ABC system, the activity rates are $0.25 per transaction and $2 per customer-support call.

a) Compute revenue, costs, and profit margin for each customer.

Enter negative numbers with a minus sign, i.e., a loss of $200 should be entered as -200, not as (200) or ($200).

4. Even though Oracle has the second market share in the database industry (33.7%, behind IBM's 34.1% in 2004), it has chosen to let IBM'DB2 customers use their future products (iFlex, Retek and Fusion). It may seem all the more strange to form this kind of "alliance" with the competitor just ahead of them. Analyze Oracle’s strategy using the theory of lock-in and Compatibility.

The Company borrowed $206,116  at 7.89 % to be repaid quarterly over 30 years. They just remitted payment number 74. How much interest did the bank receive in year 3?

The Company borrowed $266,779 at 8.51 % to be repaid quarterly over 30 years. They just remitted payment number 74. How much interest did the bank receive in year 3