1. Which of the following z-scores is located furthest AND below the mean of a distribution?

a.z = -3.0

b.z = -1.0

c.z = +1.0

d.z = +3.0

2. All of the following apply to the concept of variability EXCEPT:

a.it is a form of inferential statistics

b.it is a form of descriptive statistics

c.it measures the extent to which scores deviate from the mean

d.it measures distance/spread of scores in a distribution

3. Which statement best describes the concept of a z-score?

a.they standardize a distribution, but do not provide any information about location

b.they standardize a distribution and allow for comparisons between different distributions

c.they standardize a distribution and are always equal to raw scores

d.they do not standardize a distribution, but do provide information about location

4.What does the Unit Normal Table tell you about a distribution?

a.the standardized proportions of a normal distribution corresponding to raw scores

b.the standardized proportions of a skewed distribution corresponding to raw scores

c.the standardized proportions of a normal distribution corresponding to z-scores

d.the standardized proportions of a skewed distribution corresponding to z-scores

5.With respect to probability and sampling:

a.each individual in a population should have an equal chance of being selected for a sample

b.sampling should occur with replacement

c.both answers a and b

d.none of the above

27. Chapter 7: Question 27

Which statement best defines the concept of the distribution of sample means?

a.it is a distribution of all the possible means of a specified (n) taken from a population

b.it is a distribution of sample statistics (a sampling distribution)

c.it is a distribution of all the possible raw scores taken from a population

d.both answers a and b

29. Chapter 7: Question 29

All of the following are characteristics of a distribution of sample means EXCEPT:

a.sample means should occur mostly near this distribution's mean

b.with larger n's, this distribution becomes more variable

c.with smaller n's, this distribution becomes more variable

d.all of the above

31.) Hypothesis testing is a form of _________, which uses _________ data to evaluate a hypothesis about a _________.

            a. descriptive statistics; population; sample

            b. inferential statistics; population; sample

            c. inferential statistics; sample; population

            d. descriptive statistics; sample; population

33.Which of the following is true about the concept of statistical power?

a.it is a useless piece of information with respect to hypothesis testing

b.it is the probability that a hypothesis test will erroneously reject a true null hypothesis

c.it is the probability that a hypothesis test will correctly reject a false null hypothesis

d.it is also known as Type I Error (?)

35.) Which of the following does NOT apply to Type II Errors?

            a. Type II Error influences the power of a hypothesis test

            b. they occur when a researcher fails to reject a false null hypothesis

            c. the probability of a Type II Error is known as beta (β)

            d. all of the above apply

36. Chapter 9: Question 36

Under which conditions will it be very difficult to detect a treatment effect using the t-statistic?

a.with a small sample size and low sample variance

b.with a small sample size and high sample variance

c.with a large sample size and high sample variance

d.with a large sample size and low sample variance

37. Chapter 9: Question 37

All of the following are assumptions of the one-sample t-test EXCEPT:

a.scores come from independent observations

b.the population that is sampled is skewed

c.the population that is sampled is normal

d.none of the above (all of the above are assumptions)

39. Chapter 9: Question 39

What is the term for the estimated standard distance between a sample mean (M) and the population mean (u)?

a.estimated standard variance

b.estimated standard deviation

c.estimated standard error

d.estimated standard treatment effect

In this assignment, you will use regular JavaScript and the Fetch API to read an external JSON data file from the server and then add the data from each student object into new rows in an existing HTML table.

This assignment is very similar to the Adding Rows to a Table assignment. The main difference is that you will:

• Use the Fetch API instead of using the AJAX API to read the external JSON data file.

Set Up This Assignment

Add this HTML to your "week11/index.html" file. Put your name in the meta author tag (highlighted below).

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Using Fetch to read a JSON file</title>
    <meta name="description" content="This is a simple example using Fetch to read a 
       JSON string then add student data as rows in an HTML table.">
    <meta name="author" content="Your name here">

    <!-- link to external CSS file -->
    <link rel="stylesheet" href="css/styles.css?v=1.0">
</head>
<body>
    <!-- Content of the page goes here. -->
    <main>
        <h1>Use Fetch to read JSON data</h1>
        <section class="intro">
            <h2>Introduction</h2>
            <p>In this assignment you will use Fetch to read in an external JSON data file. 
                You will then display the contents in a web page as new rows in an existing table. 
            </p>
        </section>

        <section class="student-info">
            <h2>Student Information from JSON file</h2>
            <p class="loading">Loading student data...</p>
            <table id="student-table">
              <thead>
                <tr><th scope="col">Name</th><th scope="col">Favorite Hobby</th><th scope="col">Favorite Color</th></tr>
              </thead>
              <tbody>
              </tbody>
            </table>
        </section>
    </main>
    
    <!-- link to external JS file -->
    <script src="js/scripts.js"></script>
</body>
</html>

JSON Data
You will also use the same students.json file that you used in the week9 assignment. Put the JSON file in a "data" subdirectory: "week11/data/students.json"

CSS Stylesheet
You will also use the same CSS file that you used in the week9 assignment. Put the CSS file in a "css" subdirectory: "week11/css/styles.css"

JavaScript
Your "week11/js/scripts.js" file will use the fetch API to read an external JSON data file, then add student data as rows to an existing table. This page contains sample code that uses the fetch API: Fetch API: An Example

This displayData function needs to do these things:

• Create a DOM fragment.
• Loop through the "students" object.
• Read the first name, last name, favorite hobby, and favorite color from each object.
• Create a table row "tr" element.
• Create a table data "td" element for each column in the row.
• Add the student's name to the first column of the row using createTextNode, template literals, and appendChild. The first column should contain both the student's first and last name in this format - "lastname, firstname" - then append the td to the tr element.
• Add the student's hobby in the second column, then append it to the tr element.
• Add the student's favorite color in the third column, then append it to the tr element.
• Add the tr to a DOM fragment
• Finally, after you've built your DOM fragment append it the "#student-table tbody" element.
• Use querySelector to read the "p.loading" paragraph.
• Change the class attribute of that paragraph from 'loading' to 'loadingHidden' using 'classList.replace': Setting CSS Styles Using JavaScript

Task 1.

For each table on the list, identify the functional dependencies. List the functional dependencies. Normalize the relations to BCNF. Then decide whether the resulting tables should be implemented in that form. If not, explain why. For each table, write the table name and write out the names, data types, and sizes of all the data items, Identify any constraints, using the conventions of the DBMS you will use for implementation. Write and execute SQL statements to create all the tables needed to implement the design.

Create indexes for foreign keys and any other columns that will be used most often for queries. Insert about five records in each table, preserving all constraints. Put in enough data to demonstrate how the database will function. Write SQL statements that will process five non-routine requests for information from the database just created. For each, write the request in English, followed by the corresponding SQL command. Create at least one trigger and write the code for it.

Tables / DDL and Insert Data have been provided below:

-- DDL to create the MS SQL tables for initial relational model for Theater Group
CREATE DATABASE Theater;

CREATE TABLE Member(
    memId       INT,
    dateJoined   DATETIME,
    firstname    VARCHAR(15),
    lastName    VARCHAR(20),
    street       VARCHAR(50),
    city        VARCHAR(15),
    state        CHAR(2),
    zip           CHAR(5),
    areaCode    CHAR(3),
    phoneNumber CHAR(7),
    currentOfficeHeld VARCHAR(20),
    CONSTRAINT Member_memId_pk PRIMARY KEY(memid));

CREATE TABLE Sponsor(
    sponID       INT,
    name       VARCHAR(20),
    street       VARCHAR(50),
    city        VARCHAR(15),
    state        CHAR(2),
    zip           CHAR(5),
    areaCode    CHAR(3),
    phoneNumber CHAR(7),
    CONSTRAINT Sponsor_sponId_pk PRIMARY KEY(sponID));

CREATE TABLE Subscriber(
    subID       INT,
    firstname    VARCHAR(15),
    lastName    VARCHAR(20),
    street       VARCHAR(50),
    city        VARCHAR(15),
    state        CHAR(2),
    zip           CHAR(5),
    areaCode    CHAR(3),
    phoneNumber   CHAR(7),
    CONSTRAINT Subscriber_subId_pk PRIMARY KEY(subID));

CREATE TABLE Play(
    title            VARCHAR(100),
    author            VARCHAR(35),
    numberOfActs   SMALLINT,
    setChanges        SMALLINT,
    CONSTRAINT Play_title_pk PRIMARY KEY(title));

CREATE TABLE Production(
    year            SMALLINT,
    seasonStartDate   VARCHAR(7),
    seasonEndDate   VARCHAR(7),
    title            VARCHAR(100),
    CONSTRAINT Prod_year_seasStDate_pk primary key(year, seasonStartDate),
    CONSTRAINT Prod_title_fk FOREIGN KEY(title) REFERENCES Play(title));

CREATE TABLE Performance(
    datePerf        VARCHAR(7),
    timePerf        VARCHAR(10),
    year            SMALLINT,
    seasonStartDate   VARCHAR(7),
    CONSTRAINT Performance_date_pk PRIMARY KEY(datePerf,year),
    CONSTRAINT Performance_yr_seasStart_fk FOREIGN KEY(year,seasonStartDate) REFERENCES Production(year, seasonStartDate));

CREATE TABLE TicketSale(
    saleID       INT,
    saleDate   DATETIME,
    totalAmount   DECIMAL(6,2),
    perfDate   VARCHAR(7),
    perfYear   SMALLINT,
    subId       INT,
    CONSTRAINT TicketSale_ID_PK PRIMARY KEY(saleId),
    CONSTRAINT TicketSale_perfDate_fk FOREIGN KEY(perfDate,perfYear) REFERENCES Performance(datePerf,year),
    CONSTRAINT TicketSale_subId_fk FOREIGN KEY(subId) REFERENCES Subscriber(subId));

CREATE TABLE DuesPayment(
    memId        INT,
    duesYear   SMALLINT,
    amount       DECIMAL(5,2),
    datePaid   DATETIME,
    CONSTRAINT DuesPayment_memId_year_pk PRIMARY KEY(memid, duesyear),
    CONSTRAINT DuesPayment_memId_fk FOREIGN KEY(memid) REFERENCES Member(memid));

CREATE TABLE Donation(
    sponId            INT,
    donationDate   DATETIME,
    donationType   VARCHAR(20),
    donationValue   DECIMAL(8,2),
    year            SMALLINT,
    seasonStartDate   VARCHAR(7),
    CONSTRAINT Donation_sponId_date_pk PRIMARY KEY(sponId, donationDate),
    CONSTRAINT Donation_sponId_fk FOREIGN KEY(sponId) REFERENCES Sponsor(sponId),
    CONSTRAINT Donation_year_seasStartDate_fk FOREIGN KEY(year,seasonStartDate) REFERENCES Production(year, seasonStartDate));

CREATE TABLE Ticket(
    saleId            INT,
    seatLocation   VARCHAR(3),
    price            DECIMAL(5,2),
    seattype        VARCHAR(15),
    CONSTRAINT Ticket_saleid_pk PRIMARY KEY(saleId, seatLocation),
    CONSTRAINT Ticket_saleid_fk FOREIGN KEY(saleid) REFERENCES TicketSale(saleId));

CREATE TABLE Member_Production(
    memId            INT,
    year            SMALLINT,
    seasonStartDate   VARCHAR(7),
    role            VARCHAR(25),
    task            VARCHAR(25),
    CONSTRAINT Mem_Prod_Id_year_seas_pk PRIMARY KEY(memId, year, seasonStartDate),
    CONSTRAINT Mem_Prod_memId_FK FOREIGN KEY (memid) REFERENCES Member(memId),
    CONSTRAINT Mem_Prod_yr_seasStartDate_fk FOREIGN KEY(year,seasonStartDate) REFERENCES Production(year,seasonStartDate));

INSERT DATA:

-- insert some records

INSERT INTO Member values(11111,'01-Feb-2015', 'Frances','Hughes','10 Hudson Avenue','New Rochelle','NY','10801','914','3216789','President');
INSERT INTO Member values(22222,'01-Mar-2015', 'Irene','Jacobs','1 Windswept Place','New York','NY','10101','212','3216789','Vice-President');
INSERT INTO Member values(33333,'01-May-2015', 'Winston', 'Lee','22 Amazon Street','New York','NY', '10101','212','3336789',null);
INSERT INTO Member values(44444,'01-Feb-2015', 'Ryan','Hughes','10 Hudson Avenue','New Rochelle','NY','10801','914','5556789','Secretary');
INSERT INTO Member values(55555,'01-Feb-2015', 'Samantha', 'Babson','22 Hudson Avenue','New Rochelle','NY','10801','914','6666789','Treasurer');
INSERT INTO Member values(66666,'01-Feb-2015', 'Robert', 'Babson','22 Hudson Avenue','New Rochelle','NY','10801','914','6666789',null);

INSERT INTO Sponsor values(1234, 'Zap Electrics', '125 Main Street','New York','NY', '10101', '212','3334444');
INSERT INTO Sponsor values(1235, 'Elegant Interiors', '333 Main Street','New York','NY', '10101', '212','3334446');
INSERT INTO Sponsor values(1236, 'Deli Delights', '111 South Street', 'New Rochelle','NY','10801', '914','2224446');

INSERT INTO Subscriber values(123456, 'John','Smith','10 Sapphire Row', 'New Rochelle','NY','10801', '914','1234567');
INSERT INTO Subscriber values(987654, 'Terrence','DeSimone','10 Emerald Lane','New York','NY', '10101','914','7676767');

INSERT INTO Play values('Macbeth','Wm. Shakespeare', 3,6);
INSERT INTO Play values('Our Town','T. Wilder', 3,4);
INSERT INTO Play values('Death of a Salesman','A. Miller', 3,5);

INSERT INTO Production values(2015,'05-May', '14-May', 'Our Town');
INSERT INTO Production values(2014,'14-Oct','23-Oct','Macbeth');

INSERT INTO Performance values('05-May','8pm',2015,'05-May');
INSERT INTO Performance values('06-May','8pm',2015,'05-May');
INSERT INTO Performance values('07-May','3pm',2015,'05-May');
INSERT INTO Performance values('12-May','8pm',2015,'05-May');
INSERT INTO Performance values('13-May','8pm',2015,'05-May');
INSERT INTO Performance values('14-May','3pm',2015,'05-May');
INSERT INTO Performance values('14-Oct','8pm',2014,'14-Oct');
INSERT INTO Performance values('15-Oct','8pm',2014,'14-Oct');
INSERT INTO Performance values('16-Oct','3pm',2014,'14-Oct');
INSERT INTO Performance values('21-Oct','8pm',2014,'14-Oct');
INSERT INTO Performance values('22-Oct','8pm',2014,'14-Oct');
INSERT INTO Performance values('23-Oct','3pm',2014,'14-Oct');

INSERT INTO TicketSale values(123456,'01-May-2015',40.00,'05-May',2015,123456);
INSERT INTO Ticket values(123456, 'A1',20.00,'orch front');
INSERT INTO Ticket values(123456, 'A2',20.00,'orch front');

INSERT INTO TicketSale values(123457,'02-May-2015',80.00,'05-May',2015,987654);
INSERT INTO Ticket values(123457, 'A3',20.00,'orch front');
INSERT INTO Ticket values(123457, 'A4',20.00,'orch front');
INSERT INTO Ticket values(123457, 'A5',20.00,'orch front');
INSERT INTO Ticket values(123457, 'A6',20.00,'orch front');

INSERT INTO TicketSale values(000001,'01-Oct-2014',40.00,'14-Oct',2014, 987654);
INSERT INTO Ticket values(000001, 'A1',20.00,'orch front');
INSERT INTO Ticket values(000001, 'A2',20.00,'orch front');

INSERT INTO TicketSale values(000002,'9-Oct-2014',60.00,'14-Oct',2014,123456);
INSERT INTO Ticket values(000002, 'A1',20.00,'orch front');
INSERT INTO Ticket values(000002, 'A2',20.00,'orch front');
INSERT INTO Ticket values(000002, 'A3',20.00,'orch front');

INSERT INTO DuesPayment values(11111, 2015, 50.00, '01-Jan-2015');
INSERT INTO DuesPayment values(22222, 2015, 50.00, '15-Jan-2015');
INSERT INTO DuesPayment values(33333, 2015, 50.00, '01-Feb-2015');
INSERT INTO DuesPayment values(44444, 2015, 50.00, '30-Jan-2015');
INSERT INTO DuesPayment values(55555, 2015, 50.00, '28-Jan-2015');

INSERT INTO Donation values(1234, '01-Mar-2015','sound board',1250.00,2015,'05-May');
INSERT INTO Donation values(1235, '15-Apr-2015','cash', 500.00,2015,'05-May');
INSERT INTO Donation values(1236, '05-May-2015','food',500.00,2015,'05-May');
INSERT INTO Donation values(1236, '06-May-2015','beverges',200.00,2015,'05-May');
INSERT INTO Donation values(1236, '07-May-2015','snacks',100.00,2015,'05-May');

INSERT INTO Member_Production values(11111,2015,'05-May','Emily','sets');
INSERT INTO Member_Production values(22222,2015,'05-May','Mrs. Webb','costumes');

-- DDL to delete all of the tables, use only if you need to rebuild the DB
DROP TABLE Member_Production;
DROP TABLE Ticket;
DROP TABLE Donation;
DROP TABLE DuesPayment;
DROP TABLE TicketSale;
DROP TABLE Performance;
DROP TABLE Production;
DROP TABLE Play;
DROP TABLE Subscriber;
DROP TABLE Sponsor;
DROP TABLE Member;
DROP DATABASE Theater;

Brett and Lisa file taxes under the married filing jointly status. Lisa is a sales manager for an auto parts company and Brett takes care of their 3 children. In 2018, Lisa receives a promotion associated with a move to a new division located over 500 miles from their existing home. The cost to move their household items is $8,700. Lisa's employer reimburses her for $3,000 of those costs and also pays $2,100 for airfare for the entire family to fly to the new destination. Lisa's moving expenses deduction for 2018 is:

a.$5,700

b.$3,600

c.$0

d.$8,700

e.None of these choices are correct.

Ellen supports her family as a self-employed attorney. She reports $90,000 of income on her Schedule C and pays $8,000 for health insurance for her family, $2,500 for dental insurance, $4,000 for health insurance for her 23-year-old daughter who is no longer a dependent, and $3,000 for disability insurance for herself. What is Ellen's self-employed health insurance deduction?

a.$10,500

b.$12,000

c.$13,500

d.$14,500

e.$8,000

Over the years, Monica contributed $15,000 to a Roth IRA opened 10 years ago. The IRA has a current value of $37,500. She is 54 years old and takes a distribution of $25,000. How much of the distribution will be taxable to Monica?

a.$10,000

b.$0

c.$37,500

d.$15,000

e.$25,000

Jody is a physician (not covered by a retirement plan) with a salary of $40,000 from the hospital where she is employed. She supports her husband, Andre, who sells art work and has no earned income. Both are in their twenties. What is the maximum total amount that Jody and Andre may contribute to their IRAs and deduct for the 2018 tax year?

a.$5,000

b.$5,500

c.$11,000

d.$10,000

e.None of these choices are correct.

Waterbury Insurance Company wants to study the relationship between the amount of fire damage and the distance between the burning house and the nearest fire station. This information will be used in setting rates for insurance coverage. For a sample of 30 claims for the last year, the director of the actuarial department determined the distance from the fire station (x) and the amount of fire damage, in thousands of dollars (y). The MegaStat output is reported below.

1. a-1. Write out the regression equation. (Round your answers to 3 decimal places.)

2. How much damage would you estimate for a fire 7 miles from the nearest fire station? (Round your answer to the nearest dollar amount.)

1. c-1. Determine the coefficient of determination. (Round your answer to 3 decimal places.)

1. c-2. Fill in the blank below. (Round your answer to one decimal place.)

1. d-1. Determine the correlation coefficient. (Round your answer to 3 decimal places.)

1. d-3. How did you determine the sign of the correlation coefficient?

1. e-1. State the decision rule for 0.01 significance level: H₀ : ρ = 0; H₁ : ρ ≠ 0. (Negative value should be indicated by a minus sign. Round your answers to 3 decimal places.)

1. e-2. Compute the value of the test statistic for the hypothesis of β₁. (Round your answer to 2 decimal places.)

1. e-3. Is there any significant relationship between the distance from the fire station and the amount of damage? Use the 0.01 significance level.

Many drivers of cars that can run on regular gas actually buy premium in the belief that they will get better gas mileage. To determine if there is evidence to support this claim, 10 cars were used in a company fleet in which all of the cars ran on regular gas. Each car was filled first with either regular or premium gasoline, decided by a coin toss, and the mileage was recorded for a tank full. Then, the mileage was recorded again for the same cars for a tank full of the other kind of gasoline. The results are listed below in miles per gallon: Car # 1 2 3 4 5 6 7 8 9 10 Regular 16 20 21 22 23 22 27 25 27 28 Premium 19 20 24 19 25 25 26 26 28 28

The test of the variances at .10 reveals that we reject the null hypothesis. Yes or no

There is a statistically significant difference between the mean of regular gas and the mean of premium gas as evidenced by the respective sample means. Yes or no

The standard error of the mean difference is 1.969 Yes or no'

For the test of the means at .05, we fail to reject the null hypothesis. Yes or no

For the test of the means at .05, the decision is reject the null hypothesis. yes or no

For the test of the means at .05, the final conclusion within the context of the scenario is that there is sufficient evidence to indicate that regular and premium get about the same gas mileage. Yes or no

For the 2-tail test of the confidence interval, the confidence interval contains 0 . Yes or no

For the 2-tail test of the confidence interval, the decision is to fail to reject the null b/c 0 is not in the interval. Yes or no

For the 2-tail test of the confidence interval, the evidence is because 0 is in the interval. Yes or no

Because we failed to reject the null hypothesis, this indicates that there is no difference in gas mileage between premium and regular. Yes or no

Stacking pennies to the moon

1. Estimate how many pennies it would take to stack them from the earth to the moon. Give your answer in 1000s of dollars.
2. How much would all of these pennies weigh? Give your answer in tons.
3. Why did I ask you to estimate instead of giving an exact answer?

Be sure to state your assumptions and define your estimations. Include justification for these.

Use these facts (do not look up additional facts to help):

• Moon is about 238,900 miles (mi) away.
• Penny is 1.52 millimeters (mm) thick.
• There are 25.4 mm in an inch (in).
• There are 5,280 feet (ft) in a mile (mi).
• A penny weighs 2.5 grams (gm) or 0.088 ounces (oz)
• There are 16 ounces in a pound (LB)

What you should be paying attention to in order to earn a good grade:

• Of course, accuracy
• Units: You should have the unit of measurement for each measured value.
• Labels: You should label your steps; tell me what you are doing in each particular step. For example, one step might read, “I am finding how many pennies are in an inch.” I am not looking for a step by step explanation of operators (I multiplied, then I added), but the meaning of each step in the context of the problem.
• Make sure that you are using proper mathematical notation in the appropriate context. Be especially careful with the equal symbol: The expressions on either side of an equal symbol should be equal and have the same units.
• Use complete sentences in #3.
• Remember, this is about expression of a logical thought process with correct mathematical notation, so that anyone (even someone who does not know how to do this problem) could follow it and learn from it.

You might want to have someone else read it after you are done to make sure that your process is clear.