Category: Statistics homework help

Dataset Options
In many cases, researchers may have the data from their study in another software package like Microsoft Excel. However, if the data is not available in a software spreadsheet you can manually enter the data. Option 2: Manual Data Entry
In the Worksheet window, type “Age” in C1. Enter the numbers as shown in the dataset below. Enter the remaining data as shown below (set up your column labels i.e., variable). The measure reflects math anxiety and the study variables (cringe, uneasy, afraid, worried, understand) the math anxiety range is from 1–5 with low being the least and 5 the highest.
 ********See picture attached**********
Step 2: Click on Excel tab for Add Ins; if you do not see statistics; you will need to open the file option; click on Add ins; click on ok; a box will open which will allow you to choose Statistics package; place a check mark in the box and click ok. How to Run Descriptive Statistics
Now that your data is in Excel, you will look at the descriptive statistics for this dataset. Select the data in all the columns except the top that has words for the columns; however you have the file already completed and a picture of the descriptive statistics..See end of page for a copy of the excel sheet and descriptive statistics output.
Discussion Question Part 1
How could you use Excel descriptive statistics for data analysis research? Write about your experience running descriptive statistics. Use the results in the Session Window to support your response. Then add to your discussion with the information you learn writing up your analysis.
Step 3: Excel and Graphs
You will now look at graphing. Select insert graph located at the top of the sheet; highlight the data you want to use for a chart; select the type of chart; select ok. Try using the histogram  feature for one of the variables and select “Ok”. You can create other Histogram graphs by choosing different variables. You can also choose from the other ten graph choices shown on the insert chart function.
Discussion Question Part 2
What are your plans for learning more about Excel and how will the information you learned about this software be of benefit in your future analysis of research data? Copy and paste your graph(s) in a Word document and attach to your discussion response.

https://ronellekriegerprofile.weebly.com/uploads/7/4/8/4/7484534/the_importance_of_assumptions_in_multiple_regression_and_how_to_test_them.pdf
https://ics.uci.edu/~jutts/110/Lecture3.pdf
Initial Post (Due Wednesday, May 8) Copy the questions in your post.  Present your response directly below the question so that it is clear to what question you are responding to
Using the dataset associated with this thread. Select 2 explanatory continuous variables and one continuous response variable (Your choice).  
List your variables and the variable descriptions
Run a multiple regression test using either JASP or Excel.  Post all 3 of your multiple regression output tables to this thread.
Interpret the R, Adjusted R squared, ANOVA table p-value, the coefficient table p-values
Select ONE technique for assumption checking for multiple regression.  Run that technique on the variables that the STUDENT used in their post (not your variables)
Present the results (chart, table, numerical summary … whatever your evidence is that you generated) and interpret them.  Has the assumption been met?  Explain.

Use DBS2_1.1. and DataSet2.xlsx  to answer the questions in project questions and Instructions-1.docx. Please see attached documents and complete on time. Correct answers only.

 Calculate the hypothesis test p-value for the population mean with the given z-score. (Note: With two (2) tail tests you must add both tail p-values.) a. ????0: ???? ≤ 1.07 and ????a: ???? > 1.07, ???? = 2.27 

For this Final project, you will be analyzing data that was collected from the survey that I sent to you all during the first couple weeks of class! I hope you have fun learning a little more about your classmates in this Final Project.:) This dataset contains information from 178 students (98 students in STA 2023 and 80 students in MAC 1105).
NOTE: You DO NOT need to work with the actual data set for this. I have included all of the relevant summary statistics in the statements of the problems.
Complete the assignment either on paper or on the computer.

Make sure to answer all questions. 
Please try to include any sketches and work on the worksheet. If you are not able to, however, you may submit them as a separate document. (It’s just a little easier to grade when it’s all in one document.)
If you do not have access to a printer, you can hand write your asnwers on a separate sheet and upload a picture.

Upload completed worksheet to this assignment in Canvas.
If you have any questions, don’t hesitate to ask! 
NOTES/HINTS:
The degrees of freedom for these problems is large, you may need to use StatCrunch or an online calculator to find the critical values for the t-distribution:
please follow the template attached

  1. Abstract: A brief statement (few sentences at most) summarizing the purpose of the report as well as the results and what they mean in substantive rather than statistical terms. Be brief and to the point, stimulating your reader’s interest. You essentially have 15 seconds to let the reader know what’s in the report and if they should read it. 
2. Introduction: Give background and motivate the question to be investigated. Introduce the data, perhaps with visualization or descriptive statistics, but only if you think it significantly adds to the narrative. A reader could jump from here to Results. While a formal research study has explicit hypotheses, you likely won’t have any, but at least try to suggest which variables in what form you expect to be important predictors. 
3. Methodology: Describe the approach used to analyze the problem while keeping in mind that your reader likely never took or doesn’t remember ST 625. What was your approach? Why is your approach is appropriate? What are the assumptions? Are there any concerns about these assumptions? 
4. Results: Present the recommendation simply and clearly. Use graphical display, table, and discussion as you see appropriate. You are providing an answer to the question outlined in the introduction. 
5. Conclusion: Briefly summarize everything. Does the model make sense? Do the predictors seem reasonable? What does it all mean? Suggestions for further analysis or other data might be appropriate.
 6. Appendix: Screenshots of recommended R model 
Using the range of models, tools, and techniques studied in ST 625, build and present two models: one for predicting casual bike rentals using the independent variables, and another for predicting registered bike rentals. Your ultimate goal is to explain the factors that influence bike demand, and as such your model/variable selection should be based both on context and statistics. Model interpretation will be very important part of your report! What influences demand for bikes, and how, and to the extent plausible why? You should at a minimum perform linear regression using all the available independent variables as well as consider some types of complex model (terms that are higher-order, interaction, dummy), then perform variable selection/compare models. And to be very clear, casual should not be a variable used to predict registered, nor vice-versa 

 
Instructions
Scenario:
A generation ago, people used to see their doctor only when they were sick or dying. Today, preventative health care is becoming commonplace as people become more educated and empowered about their own health. Regular, routine medical check-ups can help find potential health issues before they become a problem. Early detection of problems gives the best chance for getting the right treatment quickly, avoiding any complications.
You have been employed as part of an active public health campaign that is aiming to increase routine 12-monthly check-ups. Your job is to identify groups of people with lower rates of check-ups in the last 12 months where a targeted campaign would be of most benefit.
The Behavioral Risk Factor Surveillance System (BRFSS) is a collaborative project between all of the states in the United States (US) and participating US territories and the Centers for Disease Control and Prevention (CDC). The BRFSS is a system of ongoing health-related telephone surveys designed to collect data on health-related risk behaviours, chronic health conditions and use of preventive services from the non-institutionalised adult population (≥18 years) residing in the United States. Using the prepared BRFSS data, identify demographic, social and behavioural factors that are associated with routine check- up attendance.
Dataset:
BRFSS 2024 data
Format:
Your written briefing document must consist of a 250-word executive summary and a detailed structured results section. This template will assist you with the format and information required.
Executive Summary (Marks: 25)
The 250-word summary should identify demographic, social and behavioural factors that are associated with routine check-up attendance in a statistically valid, clear and concise manner that can be understood by someone with minimal knowledge of epidemiology and biostatistics. You must identify a group or groups of people where a targeted campaign would be of most benefit.
Results:
The BRFSS:
A short summary of the study design of the BRFSS and a brief discussion of its limitations (no more than 250 words (Marks: 6)
Find a peer-reviewed primary quantitative research study in the literature that investigates the determinants of routine check-up attendance. Compare the designs between the study described in that paper and BRFSS (not more than 150 words). (Marks: 4)
Description of the population and analysis:
1) By analysing the BRFSS dataset, answer the following questions:
In your dataset, what percentage of participants reported routine check-up attendance? (Marks: 5)
Create a table of routine check-up attendance and 3 demographic factors, one of which must be binary, one numerical and one multi-category categorical (either nominal or ordinal). (Marks: 15)

Each cell should contain the appropriate summary measure and 95% confidence interval
The final column in the table should contain the p-value for statistical tests of difference or independence (i.e., tests that we covered in week 6). Footnotes should be used to indicate which statistical tests were used.

2) Examine the association between 4 social and/or behavioural factors and routine check-up attendance:

In an appropriate manner, present the results of analysis into the effect of four social and/or behavioural factors on routine check-up attendance. You must analyse a binary, numeric, nominal and ordinal factor. (Marks: 20)

For each factor you should report:

Variable name and data type
Name of measure  calculated
Results of statistical analysis performed
Statistical interpretation
The Stata output (including visible code) e.g.

For one of the identified factors, you should explore the possibility of confounding or effect modification by sex. (Marks: 10)

Perform appropriate analysis
Present STATA output (including visible code)
Report the results in a table
Interpret your result

Conduct a multivariable regression and present the results of the adjusted regression model by including the four factors you examined in your analysis of social and behavioural factors. (Marks: 10)

Present STATA output (including visible code)
Report the results in a table.
Interpret your result

Purpose of Study
As a policy researcher, the Congressional Budget Office (CBO) has asked you to explore a new dataset called the General Social Survey.  The CBO would like you to conduct a preliminary statistical analysis to describe the sample characteristics in the dataset and write a report for the CBO. They believe this dataset is representative of the American people and can be used to help leaders make important social and social policy decisions.  
Research Questions and Hypothesis
What are the demographic characteristics in the GSS dataset?
There is no hypothesis for this assignment.
Measures (Variables)
AGE, MARITAL, DEGREE, BORN, RACE1

Directions:
The requirement of this assignment is to: Call in the appropriate dataset, select the columns (i.e. variables), and possibly rows (i.e. observations), of interest, and run frequency distributions for your chosen variables. You should include: 
Your program.
The output that displays three of your variables in frequency tables.
A few sentences describing the results of your frequency tables.

Jaxson had 12 grades in math in the first quarter. If his teacher allows him to drop his two lowest scores, how will this affect his mean, median, and mode?