Need help with excel spreadsheet regression and correlation.Attachment 1Attachment 2Regression and Corellation Five Questions Remember to show how you got your results in the appropriate cells. For questions using functions, show the input r1 Create a correlation table using Compa-ratio and the other interval level variables, except for SalaSuggestion, place data in columns T – Y.What range was placed in the Correlation input range box:Place C9 in output box. b What are the statistically significant correlations related to Compa-ratio? c Are there any surprises – correlations you though would be significant and are not, or non signific d Why does or does not this information help answer our equal pay question? 2 Perform a regression analysis using compa as the dependent variable and the variables used in Q1including the dummy variables. Show the result, and interpret your findings by answering the follSuggestion: Place the dummy variables values to the right of column Y.What range was placed in the Regression input range box:Note: be sure to include the appropriate hypothesis statements.Regression hypothesesHo:Ha:Coefficient hyhpotheses (one to stand for all the separate variables)Ho:Ha:Place B36 in output box. Interpretation:For the Regression as a whole:What is the value of the F statistic:What is the p-value associated with this value:Is the p-value < 0.05?What is your decision: REJ or NOT reject the null?What does this decision mean?For each of the coefficients:What is the coefficient’s p-value for each of the variables:Is the p-value < 0.05?Do you reject or not reject each null hypothesis: Midpoint Age What are the coefficients for the significant variables?Using the intercept coefficient and only thesignificant variables, what is the equation? Is gender a significant factor in compa-ratio?Regardless of statistical significance, who gets paidmore with all other things being equal?How do we know? Compa-ratio = Perf. Rat. 3 What does regression analysis show us about analyzing complex measures? 4 Between the lecture results and your results, what else would you like to knowbefore answering our question on equal pay? Why? 5 Between the lecture results and your results, what is your answer to the questionof equal pay for equal work for males and females? Why? functions, show the input range when asked. vel variables, except for Salary. T= Significant r = and are not, or non significant correlations you thought would be? and the variables used in Q1 along withndings by answering the following questions. Service Gender Degree he question Compa- Midpointratio Age Performa Servicence Raise Degree Gender




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.