The year is 1979. A consortium of foreign car manufacturers starts running an ad

The year is 1979. A consortium of foreign car manufacturers starts running an advertising campaign claiming that a recent study showed that foreign cars have significantly better fuel efficiency than domestic vehicles. The advertisement goes on to explain that this is due to the superior technology
of foreign manufacturers. Detroit becomes concerned about this claim, particularly in relation to the high gas prices at the time. The big US auto makers ask your consulting company to look into this advertisement, to assess its accuracy, and suggest a possible counter-campaign.
Note: please copy/paste the STATA text output of any relevant regressions into your paper as anappendix. Normally, you wouldn’t do this in a real report, but it helps me understand what went wrong if your answers are off.
Using the auto.dta data that comes with STATA, do the following and write up your work into a cohesive report for the customer (this will probably come out to 4-6 pages with all the plots that you will want to include):
1. Do a quick check of the original claim – plot MPG versus domestic/foreign for the provided data.
Do the foreign cars look like they are more efficient on average? Do a quick regression of MPG
versus domestic/foreign. Remember the STATA command for making indicator variables:
tabulate [variable], generate([output variable name]). What is the average difference in MPG
between foreign and domestic cars? Is this figure statistically significant?
2. The US auto makers point out that US cars are generally bigger, so you would expect them to have lower MPG. [note: you can quickly check the mean of a variable by using the command “mean([variable])”. You can check the mean of just foreign/domestic cars by using the
command “mean([variable]) if [indicator variable name] == [0 or 1]”. An example: mean(weight)
if fd1 == 1] Look into this effect by plotting mpg versus weight (showing the foreign and
domestic points as different colors), then doing a regression of MPG versus weight and
domestic/foreign. Is there a noticeable difference between domestic/foreign on the plot? What does the regression say – is your foreign/domestic indicator variable significant? What does it mean that this variable is significant/not significant?
3. You also consider that engine size might have something to do with MPG and that domestic cars probably have larger engines. Check out this hypothesis by doing another regression of MPG
versus engine displacement and foreign/domestic. Which variables are significant in this regression? Interpret/explain what the regression results mean.
4. Do a regression of MPG against weight, displacement, and foreign/domestic (ie, using weight, displacement and the foreign/domestic indicator variable to predict MPG). Compare the R-squared, adjusted R-squared, and coefficient confidence intervals from this regression to the
two prior regressions (where MPG was a function of weight and displacement individually).
Which of these three models is the best?
5. Using any model (including the three above) that you chose as the best option, interpret the
results for the client (the US car makers). What are your findings from this work? What does this mean for them? How might they use your findings to create their own advertising campaignto counter the campaign by foreign manufacturers?
Note: if you think other regressions, plots, or comparisons would help your case here, feel free to pursuethem.

Unit 7 Assignment: Creating Select Queries Outcomes addressed in this activity:

Unit 7 Assignment: Creating Select Queries
Outcomes addressed in this activity:
Unit Outcomes:
Describe simple SELECT statements with one table.
Use SELECT statements to retrieve data from one table.
Course Outcome:
IT163-4: Use Structured Query Language (SQL) to manage data.
Purpose
You will practice using SQL in the Access environment. You will examine data from a sample database using simple, single table select queries.
Assignment Instructions
Using the model car sample database provided, create queries to demonstrate a variety of simple, single table select query functionality to include selecting more than one field, using the where clause, using alias’, working with dates, sorting and using relational and logical operators.
Open the sample database.
For this assignment you will use this sample database: IT163_ModelCarSampleDatabase.accdb
Create the five queries as detailed below. You may create these queries using the query design view or you may manually write the SQL code in the SQL view.
a. Select the Company field from the Customers table.
Save as QueryA. Run the query to see the subset of data produced. Verify that the results are correct.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 8: “Selecting Data with Queries / Creating a Query / Working with Query Fields / Adding Criteria to Your Queries / Saving a Query”
b. Modify QueryA to sort the output in alphabetical order.
Save as QueryB. Run the query to see the subset of data produced. Verify that the results are correct.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
c. Select the Description, Cost and QtyInStock fields from the Products table for all records with category “Trucks.” Sort by cost from lowest to highest cost.
Save as QueryC. Run the query to see the subset of data produced. Verify that the results are correct.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 8: “Selecting Data with Queries / Creating a Query / Working with Query Fields / Adding Criteria to Your Queries / Saving a Query”
d. Select the OrigCustDate, FirstName, and LastName from the Contacts table for all records with the state of Texas (“TX”) and OrigCustDate of January 1, 2013 or later. Display first and last name together as Customer Name.
Save as QueryD. Run the query to see the subset of data produced. Verify that the results are correct.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 9: “Using Operators and Expressions in Access / Introducing Operators / Using Operators and Expressions in Queries / Using Multiple Criteria in a Query / Entering Criteria in Multiple Fields”
e. Select the Company, CurrentBalance and State from the Customers table for all records with a current balance greater than zero and a state of New York or Connecticut. Sort by CurrentBalance from highest to smallest value.
Save as QueryE. Run the query to see the subset of data produced. Verify that the results are correct.
Document your results for submission.
In a Word document, copy each of the questions from above in BOLD. After each question, place the SQL code. After the SQL code, place a screenshot of the successful execution from Access showing the correct results were garnered when you ran each query. Start a new page for each question.
Hint: you can copy your SQL code as plain text from the SQL view. Right-click your query and choose SQL View or use the View option from the ribbon.
Example Query Output:
IT163_Example_Output_1.docx
Assignment Requirements
Submit a single Word document with all of the documentation for each query as described in the assignment instructions.
Directions for Submitting Your Assignment
Submit the completed document to the Unit 7 Assignment Dropbox by the deadline. Save the file as: IT163_Unit7_Lastname.docx.
Review the rubric before beginning this activity.

The expected output for this take-home is as follows: ● A report (powerpoint) th

The expected output for this take-home is as follows:
● A report (powerpoint) that describes your findings. It should take the reader about 10 minutes to read through your report
● The Python or R code you used to complete your analysis. Please show your work and include all steps that you performed along the way (eg EDA). Please share the .ipynb or .R file in your submission.
What we are looking for:
● Good code quality.
● Good communication skills. A clear narrative around the results you are finding. An explanation of the methodology choices that you made and why.
● Strong sense of ownership in how you approach the problems. Pretend this was your real job. How would you approach the problems in that case?

This econometrics assignment consists of creating a multiple linear regression m

This econometrics assignment consists of creating a multiple linear regression model with commentary on the findings and results of each step of the model. The variables as well as the data can be freely chosen: it is important that all the data comes from a reputable source.
Attached you can find two Powerpoint presentation of project that were made beforehand, with the relative model inside of them. If it is possible, I would prefer a document where there are screenshots of the relative graphs and calculations in R, as it is shown in the two examples.
I hope I’ve been clear enough, if not do not hesitate to contact me and I cannot thank you enough for this 🙂

Unit 6 Assignment: Data Validation and Security Outcomes addressed in this Assig

Unit 6 Assignment: Data Validation and Security
Outcomes addressed in this Assignment:
Examine data validation concepts.
Use data validation in a form in Microsoft Access.
Apply Encryption to an Access database.
Course Outcome:
IT163-3: Create forms to input data.
Purpose
The form is the mechanism for transferring data from the user into the program and back again. Understanding how the form is used and how data is validated is essential to building an interactive database application. In this assignment, you will extend your knowledge of forms to include working with a form with subform, the use of controls in a form and data validation.
Assignment Instructions
You will create a form for the Customer table with a subform for the Customer Contacts table so that data can be entered into both tables at the same time. You will also add controls and apply data validation to several fields in the Customer form. You will also apply encryption to password protect your database.
Open the sample database.
For this assignment you will use this sample database:
IT163_ModelCarSampleDatabase.accdb
You will apply encryption to your database and use the password “PurdueGlobal.”
For extra help see Optional Resources for Assignment under the Academic Tools, Library link:
Reference:
Encrypt a database by using a password
https://support.microsoft.com/en-us/office/encrypt-a-database-by-using-a-database-password-12aa0e5c-34c6-4957-af3b-b5f5cfa9a766
Create a form with subform for the Customer (main form) and Customer Contacts tables (subform).
Reference:
Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 19: “Working with Form Controls / Working with Subforms”
Name the new form with subform CustomerContactSubForm and save it as a new form object in your database.
You will add validation and controls for the Customer data as follows. Use the validation rule with validation text to ensure a custom error message is displayed when a rule is violated where appropriate:
Company – Validate that field is not left blank
Address – Validate that field is not left blank
City – Validate that field is not left blank
State – Create a dropdown box control (include at least three states in the list)
ZipCode – Validate that field is at leave five numeric digits
Phone – Validate that field is not left blank and add an appropriate input mask
Fax -Validate that field is not left blank and add an appropriate input mask
Email – Validate that field is not left blank
WebSite -Validate that field is not left blank
Note: No validation required for the remaining fields.
Reference:
Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 19: “Working with Form Controls / The Combo Box and List Box controls”
Ulrich, L. A. & Cook, K. (2019). Access 2019 for dummies. Wiley.
Chapter 7: “Types, Masks, and Triggers”
For extra help see Optional Resources for Assignment under the Academic Tools, Library link:
Restrict Data Input by Using Validation Rules
https://support.microsoft.com/en-us/office/restrict-data-input-by-using-validation-rules-b91c6b15-bcd3-42c1-90bf-e3a0272e988d
Add one new record to the Customer table and one new record to the CustomerContacts table using the form with subform. Use your own last name in the Company field in the Customer table entry and in the Last Name field in the CustomerContacts table entry. The other data can be of your own choosing.
Save your Microsoft Access database file for submission.
Assignment Requirements
For this assignment, you will submit your entire Microsoft Access database.
Directions for Submitting Your Assignment
Name your file according to this convention: IT163_Unit6_Lastname.accdb (use your own last name of course). Submit your completed assignment to the Unit 6 Dropbox by the deadline.
Review the rubric before beginning this