Category: Data science

You must be proficient in using software SIMUL8. Use the software to solve a Data analysis/business analysis case.  The main body of the report (the executive summary) should not exceed 6 types of pages of A4 paper (11 point font, single spacing). You should also include a technical appendix with a maximum length of 8 pages.    Furthermore details are included in the 
Simulation Project 2024.docx . A suitable bid will be accepted.

You must be proficient in using software SIMUL8. Use the software to solve a Data analysis/business analysis case.  
The main body of the report (the executive summary) should not exceed 6 types of pages of A4 paper (11 point font, single spacing). You should also include a technical appendix with a maximum length of 8 pages.    Furthermore details are included in the Simulation Project 2024.docx . 
A suitable bid will be accepted.

Include the numbers on the table that is attached. DO NOT include the Questions or other content from these instructions. 
1) Describe functional dependency ONLY; 
– NOT full functional dependency, or partial dependency, or transitive dependency. 
– Hint – review the Functional Dependencies Topic in the Terms and Concepts discussion. While you may incorporate the formal definition, you must explain the concept in your own words, using fields names and values from this exercise. 
Identify the functional dependencies that exist in the table attached. All attributes should be included at least once. There may be more than one row of functional notation needed. 
2) Identify a primary key for the table attached. 
Indicate whether there are any alternate keys (for this table) 
explain each of the above choices.
3) Is the table in 3NF? 
If not, explain why – (provide specific rationale, use field names and values in the table to demonstrate your understanding). 
Explain what normal form the table provided is in. 
4) Once you have determined the format for 3NF, provide the create table commands to create the tables as if you were to create the tables in SQLite or MS ACCESS.
APA guidelines, spelling, grammar, file name 
Please check against AI and Turnitin for plagarism.
**Turnitin report must have (less than) <15% similarity score. Please use open source references that do not require user login or registration to access.**  Course Hero may not be used as reference.

For this discussion, read the article below (Lai, et al., 2019). Begin your discussion with an overall reaction to the study and then respond to the following
1. On p. 952, the authors state that selection bias may exist in their study. How could the selection process have been improved upon in their study to reduce its likelihood?
2. Is there enough evidence from this study to suggest the discontinuance of using bone mineral density (BMD) as a detector of osteoporotic fractures?

The research
will address the following questions and hypotheses:
Question 1: Can
alternative data sources, such as social media activity and transaction
history, augment the accuracy of credit risk assessment compared to
traditional credit scoring systems?
Question 2: What
machine learning algorithms, when applied to credit risk modelling,
proffer
the highest predictive accuracy and efficiency?
Question 3: How
can the transparency and fairness of credit risk models be improved to
provide actionable insights for lending institutions?
Through an
in-depth investigation of these questions, this research aims to stipulate valuable
insights and solutions to the financial industry, ultimately bettering credit
risk modelling and
lending practices
in Mauritius.

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