sql server - Is there an appropriate way to show correlation or causation from a SQL query? -

-

If there is a way that can provide a function to show correlation or earnings from Microsoft Access or SQL Server SQL, then I Be curious and select the results and its results.

This is basically a case scenario:

Assume that you have two tables, table student carservehys and table online course review . At the forefront, most of these two tables are unrelated, but the curriculum may be based on name, for example "England 101".

studentCourseServveys is a table that captures the data that students submit to their individual course surveys at the end of one semester. For example, in the last days of class students, on the basis of those things, the form is obtained to rate the train such as "the exams were related to the actual lecture material", "the trainer was ready on time" and then the end They have short answer opportunities to give them additional comments in

Online Counselio is a table used by the internal department which reviews content on the online component of the courses. For example, there are individual teaching designers in this department who have submitted various courses to the Blackboard for review. They review the content, delivery, curriculum structure and so on and so forth. After this the course is given its comments, scores, etc.

As already mentioned that most of the tables will be unrelated but we say that someone wants to show a relation that the results of online course reviews can in some way indicate that these online reviews Due to the quality of the overall course was better and it was shown in the students' reactions on the basis of their survey. result. (Basically, there are course surveys in the curriculum with an online course review score of 10, where a great majority of students evaluated it as excellent, the content was relevant, the teacher was ready, etc., to indicate That improvement in the online course has been translated to improve the quality of the individual and the overall category.)

It is almost a statistician A looks like a unique job, but I want to know whether this query can be shown on a query basis, in Access or SQL Server, I know that you can easily easily have two tables with a foreign key And then in a statement can get the results of a survey and review of the online course, but it does not really say anything. I think that in order to show any kind of relationship you will need to clarify any trend in any given period.

Thank you.

I would suggest creating a query with three values ​​- the name of the course (for example, ENG101 ), Student ratings and online course rating. In SQL Server, you can save the result as a .csv file. Do this, then open it in Excel and use R-Square to find two or three columns. Closer to R Square 1, close to two matches. 1 means a complete correlation of 0 does not mean any relation, and 1 means related, but in a polar opposite way


Comments

Post a Comment

Popular posts from this blog

import - Python ImportError: No module named wmi -

-
I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error < Code> traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, &
Read more

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla
Read more

c# - MySQL Parameterized Select Query joining tables issue -

-
I am using parameterized select questions in conjunction with my program and it works entirely, When I try to join the table Everything I have done is a small fraction: using (MySqlCommand cmd = new MySqlCommand (paramQuery) ToSql (), Connection)) /etc/ paramQuery.ToSql () Equal: "Select TableOne ID, Tableon, Department, Tablet. One by name table, Table 2 h Yes TableOnEID = @Pharmak "* / for (Int Index = 0; Index and Lt; ParamariX Parameter (.c calculation; Index ++) Cmd.Parameters.AddWithValue (paramQuery.Parameters (). ElementAt (index). , ParamQuery.Parameters (). ElementAt (index) .Value); / * ParamQuery.Parameters (). ElementAt (index) .k = "@most 0" paramQuery.Parameters (). ElementAt (index) .Value = "tableTwo.ID" * / MySqlDataReader Reader = cmd.ExecuteReader (); While (reader.Read ()) {// do stuff} } One of the tables I attempt to join is For the table, two with the same id for all. Is there something that I'm doing wrong?
Read more