{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Labels and Correlation","Regression","Medgraph Caculation"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Labels and Correlation","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,3,12],[0,1,0,12],[17,6,17,7],[19,6,19,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[null,"MedGraph - PC: A programme to graphically depict mediation among three variables"]
[]
[]
[]
[null,null,"1) Enter the labels of the three variables"]
[]
[]
[null,null,null," Independent variable",null,null,"Fut Pos"]
[null,null,null," Mediating variable",null,null,"Optimism"]
[null,null,null," Outcome variable",null,null,"Subj Hap"]
[]
[]
[null,null,"2) Enter the raw correlations among these three variables"]
[]
[]
[null,null,null,null,null,null,"Optimism",null,"Subj Hap"]
[null,null,null,"Fut Pos",null,null,0.60299999999999998,null,0.57399999999999995]
[null,null,null,"Optimism",null,null,null,null,0.69]
[null,null,null,"Sample size",null,null,270]

{"sheet":"Regression","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,2,7,8],[13,2,13,8],[20,3,20,8],[14,3,14,8],[0,1,0,11]]}
[]
[]
[null,null,"MedGraph - PC: A programme to graphically depict mediation among three variables"]
[]
[]
[null,null,"Optimism regressed on Fut Pos"]
[null,null,"This means that Optimism is the dependent variable  and Fut Pos is the independent variable. Once you have computed this equation, enter the following information:"]
[]
[null,null,null," B (unstandardised regression coefficient)",null,null,null,0.66100000000000003]
[null,null,null,"SE (standard error)",null,null,null,5.2999999999999999E-2]
[]
[]
[null,null,"Subj Hap regressed on Fut Pos and Optimism"]
[null,null,"In this regression, Subj Hap is the dependent variable and Fut Pos and Optimism are entered simultaneously as independent variables. In addition to Bs and standard errors, obtain and enter part correlations (in SPSS, tick on 'Statistics'and then 'Part and partial correlations'). Be sure to enter the 'part correlation' (also known as the semi-partial correlation), not the 'partial correlation'."]
[null,null,null,"Optimism"]
[null,null,null,"B (unstandardised regression coefficient)",null,null,null,0.85599999999999998]
[null,null,null,"SE (standard error)",null,null,null,8.6999999999999994E-2]
[null,null,null,"Beta (standardised regression coefficient)",null,null,null,0.53300000000000003]
[null,null,null,"Part Correlation",null,null,null,0.42499999999999999]
[]
[null,null,null,"Fut Pos"]
[null,null,null,"Beta (standardised regression coefficient)",null,null,null,0.246]
[null,null,null,"Part Correlation",null,null,null,0.19600000000000001]
[]
[null,null,null,"Total R2",null,null,null,0.504]

{"sheet":"Medgraph Caculation","index":2,"n_rows":39,"n_cols":34,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,11],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[38,1,39,11],[35,5,35,7],[24,2,24,4],[24,8,24,10],[25,2,25,4],[25,8,25,10],[34,5,34,7]]}
[]
[]
[null,null,"MedGraph - PC: A programme to graphically depict mediation among three variables"]
[]
[]
[null,null,null,"Type of mediation",null,"Significant"]
[null,null,null,"Sobel z-value",null,7.7246319999999997,"p =","<0.000001"]
[]
[null,null,null,"95% Symmetrical Confidence interval"]
[null,null,null,null,"Lower"]
[null,null,null,null,"Higher"]
[null,null,null,"Unstandardized indirect effect"]
[null,null,null,null,"a*b"]
[null,null,null,null,"se"]
[]
[null,null,null,"Effective Size measures"]
[null,null,null,"Standardised Coefficients"]
[null,null,null,"  Total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32100000000000001]
[null,null,null,"  Direct:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7999999999999999E-2]
[null,null,null,"  Indirect:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28299999999999997]
[null,null,null,"  Indirect to Total ratio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.88]
[]
[]
[]
[null,null,"Independent Variable",null,null,null,"0.574*** [c]",null,"Dependent Variable"]
[null,null,"Fut Pos",null,null,null,null,null,"Subj Hap"]
[null,null,null,null,null,null,"(0.246***) [c']"]
[]
[]
[null,null,null,null,null,null,null,null,null,"0.690***"]
[null,null,null,"0.603*** [a]"]
[null,null,null,null,null,null,null,null,null,"(0.533***) [b]"]
[]
[]
[null,null,null,null,null,"Mediating Variable"]
[null,null,null,null,null,"Optimism"]
[]
[]
[null,"Note: The numerical values in parentheses are beta weights taken from the second regresssion \nand the other values are zero order correlations."]