Home

Cause and Effect Model

%3CLINGO-SUB%20id%3D%22lingo-sub-881491%22%20slang%3D%22en-US%22%3ECause%20and%20Effect%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881491%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20to%20find%20the%20correlation%20matrix%20and%20develop%20a%20cause-and-effect%20model%20to%20provide%20insights%20about%20the%20satisfaction%20level.%20Attached%20is%20the%20data%20and%20my%20solution%2C%20can%20someone%20please%20tell%20me%20if%20I%20am%20on%20the%20right%20track%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134035i8A63A844F5D4D84A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Solution.png%22%20title%3D%22Solution.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134036i46AC08620418358A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Data%204.png%22%20title%3D%22Data%204.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-881491%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881580%22%20slang%3D%22en-US%22%3ERe%3A%20Cause%20and%20Effect%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881580%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408797%22%20target%3D%22_blank%22%3E%40Ajay_Vaidya%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20not%20sure%20if%20we%20can%20answer%20whether%20or%20not%20you're%20on%20the%20right%20track.%20You%20may%20need%20to%20discuss%20this%20with%20the%20people%20who%20gave%20you%20the%20task.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20there%20a%20formula%20or%20calculation%20that%20you%20need%20help%20with%3F%20Please%20post%20the%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881582%22%20slang%3D%22en-US%22%3ERe%3A%20Cause%20and%20Effect%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B-%20Hello%2C%20thank%20you%20for%20your%20response.%20There%20is%20no%20formula%20used.%20I%20used%20the%20Regression%20analysis%20function%20to%20use%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-883651%22%20slang%3D%22en-US%22%3ERe%3A%20Cause%20and%20Effect%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883651%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408797%22%20target%3D%22_blank%22%3E%40Ajay_Vaidya%3C%2FA%3E%26nbsp%3B%20So%2C%20what%20do%20you%20need%20help%20with%3F%20Is%20there%20an%20error%20or%20a%20wrong%20result%3F%20Sorry%2C%20but%20it's%20not%20possible%20to%20tell%20from%20the%20screenshot%20what%20you%20are%20trying%20to%20achieve%20and%20whether%20or%20not%20you%20have%20achieved%20it%20or%20if%20there%20is%20an%20issue.%20You'd%20need%20to%20describe%20that%20in%20more%20detail%20or%20post%20a%20sample%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have to find the correlation matrix and develop a cause-and-effect model to provide insights about the satisfaction level. Attached is the data and my solution, can someone please tell me if I am on the right track? 

 

Solution.pngData 4.png

3 Replies
Highlighted

Hello @Ajay_Vaidya 

 

I'm not sure if we can answer whether or not you're on the right track. You may need to discuss this with the people who gave you the task. 

 

Is there a formula or calculation that you need help with? Please post the formula.

@Ingeborg Hawighorst - Hello, thank you for your response. There is no formula used. I used the Regression analysis function to use this. 

Highlighted

@Ajay_Vaidya  So, what do you need help with? Is there an error or a wrong result? Sorry, but it's not possible to tell from the screenshot what you are trying to achieve and whether or not you have achieved it or if there is an issue. You'd need to describe that in more detail or post a sample file.

Related Conversations
I have a challenging excel problem
Lyle Lazarus in Excel on
2 Replies