A vehicle’s VIN is very important for any and all paperwork, such as lease agreements, insurance details, servicing schedules, etc. The code needed to check a 17-digit VIN can be very cumbersome. So instead, we’ll use a simplified version of a VIN for this database, which is defined as follows:

• A VIN is a string of exactly 5 characters

• Each character in a VIN is a digit or an uppercase letter

• A VIN can contain any of the digits 0 to 9

• A VIN can contain any uppercase letter except I, O, and Q

• The 3rd character of a VIN is either a digit from 0 to 9 or the letter X.

Use SQL check constraints to make sure this is implemented in your database. A check constraint is a boolean expression associated with a single column using the keyword CHECK. Every time the value in that column is altered (or inserted) the system will check that the boolean expression is still true with the new value. The system will then check the condition when an UPDATE statement is attempted, and prohibit the operation if the changed value violates the condition. Add a CHECK constraint to the table Vehicle to ensure that the VIN always meets the basic requirements above. You may need to look up the documentation for CHECK on sqlite.org to double-check the exact syntax.

During the year 2018, Tosco Corporation suffered an $400,000 loss when its factory was destroyed in a flood. Assuming the corporate income tax rate is 20%, what amount will Tosco report as a non-recurring loss on its income statement for 2018? Assume floods are not common in this area.

rev: 07_04_2018_QC_CS-130717, rev: 11_21_2018_QC_CS-143121

• $80,000

• $320,000

• $400,000

• Nothing, since this does not qualify as a non-recurring item.

(a) what is an empirical rule (b) why is empirical rule useful (c) Can the empirical rule be used on any population, why and why not?

A common way that statistics are misinterpreted or misleading, depending on how it's presented or when people assume relationships that exist at a group level held at the individual level. You are required to search for examples of misleading statistics, post a link to the article/ example, and discuss why and how it is misleading.

discuss your understanding of normal distribution; why is normal distribution important in statistics and in everyday life. Give examples to underscore your points.

1. Define population and sample, identify examples of each and be able to tell the difference between them.

2. How to use the Central Limit Theorem and describe the distribution of the sample mean for a normal population, giving the mean and standard deviation of mu.

3.How to apply the Central Limit Theorem and describe the distribution of the sample mean for a non-normal population, giving the mean and standard deviation of mu.

4.How to use the 68-95-99.7 Empirical rule-of-thumb and the Central Limit Theorem to find the percentage (or probability) of an event above or below a given point or between two points.

5. How to calculate and interpret z-scores.

6. How to use the z-value to calculate and interpret the area under a normal curve.

7.How to use the area under a normal curve to calculate the corresponding z-scores.

8.How to use the 68-95-99.7 Empirical rule-of-thumb to provide an estimate of a 68, 95 or 99.7 confidence interval for both means mu and proportions p.  

9.How to use the 68-95-99.7 Empirical rule-of-thumb to provide an estimate of the results of a test of hypotheses for both mu and p.

By definition, if we say that a piece of information is accurate we mean that:

It is worth its cost to collect

It is based on correct and complete data and processed correctly as expected

It supports its purpose without any extra

It was produced in time for its intended use

It is on the subject and appropriate for the context

Cardinality as discussed in class identifies:

The number of tables in a schema

The primary and foreign key fields in a collection of data

The type of data stored in a field, text, numbers, dates, etc.

Whether a table lists objects or transactions

The number of items in one table that correspond, over time, to one item in a related table

Which of the following operational problems is NOT something an organization could address using a Referential Integrity constraint in a database:

An invoice is recorded as having been generated by an unidentified employee

A student is identified as being registered in a non-existent course

Before building a database, a developer must construct a logical representation of the database which is called a(n) ________.

Data model

Algorithm

All of the following are benefits of the database approach except

Cross-functional analysis and reporting

Data integration and sharing

Minimal data redundancy

Decentralized management of data

Pseudocode

Flowchart

An employee is listed with an unrecognized job classification

An incorrect date of birth has been saved for a student

How do you run an ANOVA test when some of the values are non-numeric?

I have a large excel database, over 100,000 cells worth of data. For the assignment, I need to see if there is a relation between the type of distribution channel (non-numeric) and the average amount of money spent (numeric). I HAVE to use ANOVA to solve this but I am not sure how. There are 11 different distribution channels and 100,000 different values for the amount of money spent. I tried using the excel function but it said I had to have all numeric cells..maybe I did something wrong?

(Compound interest with​ non-annual periods​) You just received a bonus of ​$2000. a.  Calculate the future value of ​$2000​, given that it will be held in the bank for 10 years and earn an annual interest rate of 4 percent. b.  Recalculate part ​(a​) using a compounding period that is​ (1) semiannual and​ (2) bimonthly. c.  Recalculate parts ​(a​) and ​(b​) using an annual interest rate of 8 percent. d.  Recalculate part ​(a​) using a time horizon of 20 years at an annual interest rate of 4 percent. e.  What conclusions can you draw when you compare the answers in parts ​(c​) and ​(d​) with the answers in parts ​(a​) and ​(b​)? a.  What is the future value of ​$2000 in a bank account for 10 years at an annual interest rate of 4 ​percent?

Walras’ Law

In class, for the definition of tax distorted competitive equilibrium, I stated that the prices and allocations must satisfy the government budget constraint. Show that this requirement is redundant.

Despite being universally accepted within the scientific community for over 150 years, the theory of evolution remains poorly understood by the public in some cases. Imagine that you are conversing with a friend who has some misconceptions about evolution.

describe how you would explain evolution in brief, simple terms to a non-scientist. What does “evolution” mean? How does it work? What is one concrete example that you feel provides strong empirical evidence of evolution.