Category: Data science

Description
Criminal justice agencies often gather large quantities of variables to be used in descriptive analyses—that is, to help describe situations, populations, and so on. For instance, the Department of Corrections collects data on inmates. Variables often include the following:
Crime type
Race
Gender
Originating jurisdiction (where they were convicted)
Education level
These data are often captured categorically rather than numerically. For instance, education level might be captured by simply identifying the name of the highest educational attainment that an offender learned, such as the following:
High school diploma or General Education Development (GED)
Bachelor’s degree
Associate’s degree
Similarly, race data are most often captured by recording the label of the race the offender belongs to, such as the following: 
Caucasian
African-American
Asian
Native American
Pacific Islander
These labels have no inherent numerical value because they are simply categories. Thus, they are categorical variables.
You cannot use traditional statistical analysis to investigate relationships between categorical variables because they are not numbers. Instead, you would use nonparametric tests, such as the chi-square test of independence. You will use this test to investigate the given data in this assignment.
This assignment has two steps.
Step 1: Watch both of the following videos regarding chi-square analysis:
https://www.khanacademy.org/math/statistics-probability/inference-categorical-data-chi-square-tests/chi-square-tests-for-homogeneity-and-association-independence/v/frequency-table-independent-events
https://www.khanacademy.org/math/statistics-probability/inference-categorical-data-chi-square-tests/chi-square-tests-for-homogeneity-and-association-independence/v/contingency-table-chi-square-test
Filling Out Frequency Table for Independent Events
Contingency Table Chi-Square Test
Step 2: Calculate chi-square using the data in the given table, this Chi Square Example Handout, and the Distribution Values Chart that go with this Individual Project.
Then, answer the following questions about your results:
What is the column total for Caucasian?
What is the column total for African-American? 
What is the row total for Denver County?
What is the row total for El Paso County? 
What is the row total for Pueblo County?
Are race and originating jurisdiction significantly dependent? How do you know? 
What is the final chi-square value?
How many degrees of freedom are there for this chi-square table? 
What is the value for the 0.05 significance level and 2 degrees of freedom on the Chi-Square Distribution Values Chart? 
Do you reject or accept the null hypothesis that states, “Originating jurisdiction and race are not significantly dependent (they are independent)”?
Using the Chi-Square Example Handout and the Chi-Square Distribution Values Chart as guides to figure the calculations, calculate chi-square for the following data:

Please see attached instruction. If you have any questions or concerns, please do not hesitate to ask. Thank you!

I need the part a, of this assignment in the document. All instructions are there. Use 6 references and cite w apa. Follow the instructions in part a of the document

Please see attached instruction. If you have any questions, please do not hesitate to ask. Thank you.

Managers are required to organize, interpret, and display data that is relevant to the real-world business decisions they must make in their businesses, and these business decisions must be based on relevant and reliable data. The use of analytical tools will improve your ability to use data to make these informed decisions.
In this task, you will address the business situation in the attached “Linear Regression Analysis Resources” scenario. You will access the scenario and data set by entering your student ID number in the “Start” tab of the attachment, then continuing to the “Scenario” tab. Using this data set, you will perform a linear regression analysis and write a report in which you recommend a solution by summarizing the key details of your analysis.
For full functionality of the scenario and data set attachment, you are strongly encouraged to use Microsoft Excel

it is Advanced Quantiteve Methods in Psychology, i couldn’t find this subject and data science is closest one to it. 
i need to ask to go through guiedeline attached, check if you really understand what to do, i’ve done this before myself, i normally always do myself, but this time i failed, and it’s my last chance and i need it to be done perfectly. if needed i can also share comment on previous work, so you can see, what shouldn’t be done. all needed attachments below. 

Follow the instructions on the Final Case Report Study file. 
I have written out the structure in the .pptx file, please help me with rewriting and some additions and note the content to be added in the memo. 
I’d like to be able to describe it more specifically and rewrite it since most of the concepts were generated using AI.
If possible, please send me a PowerPoint file with the text attached.
Thank you.

For this assignment, let’s create a database called “OurFinance” using Microsoft Access. This database will focus on managing personal finances. Here’s a step-by-step guide:
1. **Create a New Database**: Open Microsoft Access and create a new Blank Database. Name it “OurFinance”.
2. **Create Tables**: Create two tables: “Transactions” and “Categories”.
– **Transactions Table**: This table will store details of all financial transactions. Fields could include TransactionID (Primary Key), Date, Description, Amount, and CategoryID (Foreign Key).
– **Categories Table**: This table will store different categories of expenses or incomes. Fields could include CategoryID (Primary Key), CategoryName, and CategoryType (e.g., Expense or Income).
3. **Fill-in the Tables**: Populate the tables with sample data. In the Transactions table, you could include rows for various expenses and incomes, along with their corresponding categories in the Categories table.
4. **Build Relationships**: Establish a relationship between the Transactions table and the Categories table based on the CategoryID field. This ensures referential integrity, meaning each transaction must correspond to a valid category.
5. **Create a Query and Report**: Create a query to retrieve specific information from the database, such as total expenses for a certain period or income from a particular source. Then, generate a report to present this information in a readable format.
Now, let’s explain the importance of the concepts listed in the assignment:
– **Primary Key**: In our database, the Primary Key is the TransactionID in the Transactions table and the CategoryID in the Categories table. It uniquely identifies each record in the table and ensures that there are no duplicates.
– **Foreign Key**: The CategoryID in the Transactions table is a Foreign Key that establishes a link to the Categories table. It ensures referential integrity by enforcing that each transaction is associated with a valid category.
– **Data Dictionary**: A data dictionary documents the structure, organization, and usage of data within a database. It provides a comprehensive reference for understanding the database schema, including table names, field names, data types, and relationships. In our case, a data dictionary for “OurFinance” would describe the tables, fields, and their relationships.
– **Database Design**: Database design involves creating a structure that efficiently organizes and manages data. It includes decisions on table structure, relationships, data types, and constraints. A well-designed database like “OurFinance” ensures data integrity, reduces redundancy, and facilitates efficient querying and reporting.
– **Normalization**: Normalization is the process of organizing data in a database to reduce redundancy and dependency. It involves breaking down larger tables into smaller, related tables and establishing relationships between them. Normalization reduces the risk of data anomalies and improves data integrity. In “OurFinance,” we’ve normalized the database by separating transactions and categories into distinct tables and establishing a relationship between them.
By understanding and implementing these concepts in our database design, we ensure that “OurFinance” is robust, efficient, and maintains data integrity, which is essential for managing personal finances effectively.