Moving Excel AVERAGE formula over multiple columns
Autofill feature isn't iterating numbers properly when using the AVERAGE() formula in Microsoft Excel
I am creating an ZIP file with ZipFile in Python 2.5, it works ok so far:  import zipfile, os  locfile = "test.txt" loczip = os.path.splitext (locfile)[0] + ".zip" zip = zipfile.ZipFile (loczip, "w") zip.write (locfile) zip.close()   but I couldn't find how to encrypt the files in the ZIP file. I could use system and call PKZIP -s, but I suppose there must be a more "Pythonic" way.  I'm looking for an open source solution. so I've recently installed my first Ubuntu, to be precise, a daily build of 16.04, on my new laptop since the hardware was to new for 15.10. Now I'm in the process of setting it up and I want to install php5 and some extensions.  When I execute sudo apt-get install libapache2-mod-php5 I get the error message that there is no installation package available for php5 and libapache2.  The error message is in german, so I doubt that this would help, but anyways here it is. :-) E: For package »libapache2-mod-php5« existiert kein Installationskandidat.  Do I need to add a apt-get repository? Or what am I doing wrong? Compute Galois group of $\mathbb F_q/\mathbb F_p$ I have to compute Galois group of $\mathbb F_q/\mathbb F_p$ where $q=p^n$. I know already that $\mathbb F_q/\mathbb F_p$ is galois, so I don't need to prove it. Moreover, I know that \begin{align*}\sigma :\mathbb F_q&amp;\longrightarrow \mathbb F_q\\ x&amp;\longmapsto x^p\end{align*} is an automorphism that fix elements of $\mathbb F_p$ and thus $\sigma \in Gal(\mathbb F_q/\mathbb F_p)$.  Now, I know that if $k&lt;p^n$ then $\sigma ^k(x)=(x^{p})^k=x^{pk}\neq 1$ and thus $\sigma $ is of order $p^n$. Now if I can prove that $|Gal(\mathbb F_q/\mathbb F_p)|=p^n$, then $Gal(\mathbb F_q/\mathbb F_p)=\left&lt;\sigma \right&gt;$ and it would be finish, but I can't prove it since even $X^q-X$ split over $\mathbb F_q$, theis polynomial is not irreducible, and thus, I can't conclude. So how can I find an irreducible polynomial of degree $q$ that split over $\mathbb F_q$ ? An item to break only SPECIFIED blocks? I know that I can make certain blocks only placeable on a specified block, but what is the command to give an item that can only BREAK certain blocks? Persistent Dummy Output lualatex MWE not working Prove that $ S=\{0\}\cup\left(\bigcup_{n=0}^{\infty} \{\frac{1}{n}\}\right)$ is a compact set in $\mathbb{R}$. How do I change directory back to my original working directory with Python? Ranking based on binomial data (example: website conversions) How can I reliably get the operating system's name? How to pick one number from each sorted list so that the difference between the minimum and maximum is as small as possible? Lost/Deleted dpkg (package manager for Debian). How do I get it back? OS: Ubuntu 12.04  Accidentally deleted dpkg. Now, packages can't be installed. So, needs an dpkg installer which installs packages. Conditionals (Past Tense) In terms of conditional sentences, is it correct to say:   if you knew why I WAS here, then I wouldn't need to be here.   or   If you knew why I WERE here, then I wouldn't need to be here.   Which type of conditional is this? Type 2? I was thought at school that there are three types of conditionals. Are there more of them? Is there a one-liner that allows me to create a directory and move into it at the same time? I find myself repeating a lot of:  mkdir longtitleproject cd longtitleproject   Is there a way of doing it in one line without repeating the directory name? I'm on bash here. I noticed that my American friends tend to use the past perfect form when they use the verb mention in its past form, almost despite of the context of the sentence. I hear them say  "you had mentioned" a lot more often even in situations where the use of simple past would have been perfectly fine. Have you noticed it too and is it one of those unwritten rules, or is there a more formal explanation to it?  It seems like there was more verbs like that, but I am having a hard time remembering it now. If I do, I will edit the post and likely change the title to accommodate other verbs. How do I solve the partial differential equaiton  $u_{t} = (u_{x})^{-1}$  subject to the conditions $u(t,x) \geq 0$ and $u(0,0) = $0. Use the separation Ansatz $u(t,x) = f(t)g(x)$.  The inverse in confusing me Compute the radius of convergence of the power series $\sum_{n=0}^{\infty} n!x^n$ I have just updated to Minecraft 1.7.4 and now all of a sudden there are barely any mobs spawning.  I checked to make sure that I was in normal difficult and I saw 1 creeper but that is all.  Also I tried different difficulties. Another thing - mobs seem to to spawn normally in the nether and all other mobs except aggressive mobs spawn like they should.  Please if you know how to fix this, please help! What's the easiest way to run GUI apps on Windows Subsystem for Linux as of 2018? I searched around, and currently there are two methods suggested; installing an enhancement for Windows Subsystem for Linux and installing an XServer.  I want to know which method is the most hassle-free (easy to install AND to use), and which one is less memory-heavy.  I just want Synaptic and CMake. Why couldn't that be a builtin feature? I remember a story I have read buy could not remember the author the name or anything apart from the basic plot. The story is about some future where humanity has to fight with some aliens (not 100% sure). The story tells about a guy who was some kind of activist and who was in a prison two or more times and somehow helped humanity by being held in a prison (can't remember details). I think the story starts by saying that there is a statue in his honor that is not very well known but he did more to help humanity than famous politicians.   The story is most likely written by some famous English-speaking author, though I read it in a translation.